Posgres: view existing user permissions
=> \du
cfdvlp=> \du
List of roles
Role name | Attributes | Member of
---------------------------+------------------------------------------------------------+---------------------
-----------
cf_admin | Cannot login | {}
cloudsqladmin | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
cloudsqlagent | Create role, Create DB | {cloudsqlsuperuser}
cloudsqliamserviceaccount | Cannot login | {}
cloudsqliamuser | Cannot login | {}
cloudsqlimportexport | Create role, Create DB | {cloudsqlsuperuser}
cloudsqlreplica | Replication | {pg_monitor}
cloudsqlsuperuser | Create role, Create DB | {pg_monitor,pg_signa
l_backend}
ordadmin | | {cf_admin}
pgcfadmin | Create role, Create DB | {cloudsqlsuperuser}
postgres | Create role, Create DB | {cloudsqlsuperuser,o
rdadmin}
Comments
Post a Comment