Databases and Users in separate clusters but same project

bijunator · 2025-02-09T09:57:13.349Z

I have a project A under which I have a cluster X inside which I have a database M with user P. Now, I have created another cluster Y under project A and wishes to create user P with database M under it. Is it possible? What are the possible options here?

Andrew_Davidson · 2025-02-21T16:03:42.860Z

Under Database Access > Database Users you should see a toggle “Restrict Access to Specific Clusters/Federated Database Instances/Stream Processing Instances” which shows “Enable to specify the resources this user can access. By default, all resources in this project are accessible.” ← if you enable this you can scope a database user to a specific cluster (for example)

bijunator · 2025-03-19T10:55:31.884Z

Thanks Andrew…I reaslised that I cannot have two users with same name in a project. But I can two databases with same name under a project provided they are in separate clusters. It seems user is under the jurisdiction of project and not under individual clusters.