From: | richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | how to list privileges on the database object itself via SQL? |
Date: | 2023-04-26 16:34:21 |
Message-ID: | CAGA3vBvanu7UBtaaVv9PH25Ko==5F2wewhPWTTra8wqexdDAdQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
All,
This might sound like a silly question, but how would I list the privileges
the various roles have on the database objects themselves?
There appear to be a million ways to list the privileges on various
database objects; tables, views, foreign tables, etc. but for the life of
me there doesn't appear to an analogous way to get permissions on the
database objects themselves.
At the moment all that I've found is:
select has_database_privilege('role','db_name', 'CREATE') as can_create;
select has_database_privilege('role','db_name', 'CONNECT') as can_connect;
select has_database_privilege('role','db_name', 'TEMP') as can_temp;
Am I missing something?
Thanks,
rik.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2023-04-26 16:40:43 | Re: how to list privileges on the database object itself via SQL? |
Previous Message | fatih abztn | 2023-04-26 13:28:40 | pgBouncer - got packet 'D' from server when not linked WARNING messages |