1

Is there any other way than using queries to give GCP users r/w access to GCP postgresql DBs? I read about the Cloud SQL IAM database authentication but that only gives the user the ability to connect the DB and nothing more. For r/w permissions, there's a need to use queries to GRANT access. We have a lot of people requesting access to the DBs ( well, and a lot of DBs)and connecting to the DB and using a grant query each time is really time consuming.

Ideally I had something like this feature in Azure in mind( you can create r/w security groups and map the r/w permissions to them, and add users to those groups). I would be really happy and thankful to know if there's any other way that I haven't figured out yet.

atefeh
  • 353
  • 1
  • 2
  • 12

1 Answers1

1

I guess the answer is no. I've found that my question has being asked before: Cloud SQL Postgres - Managing Database Users, Best Practices?

atefeh
  • 353
  • 1
  • 2
  • 12
  • If your question has already been answered, it's better to close this as a duplicate of that one – camille Aug 04 '21 at 17:58
  • Hey hey, actually I can't close this as a duplicate. I don't have enough rep. I'll accept my answer tomorrow so that it will be closed (it doesn't let me accept it now) – atefeh Aug 05 '21 at 15:55
  • Accepting the answer won't close it. I'll vote to close as a duplicate and you should be able to confirm that – camille Aug 05 '21 at 16:36