On 17.11.13 2:56 AM, Luca Ferrari wrote:
On Sat, Nov 16, 2013 at 1:19 AM, Felipe Gasper <felipe@xxxxxxxxxxxxxxxx> wrote:
Hi all,
How can I retrieve:
1) each role’s privileges on a given DB
Do you mean pg_database.datacl?
http://www.postgresql.org/docs/current/static/catalog-pg-database.html
2) which users have access to a given role
3) which roles a given user can access
I guess playing with pg_roles and pg_auth_member will provide you all
the information.
Hope this helps.
Luca
Thank you!
One more question: how “stable” are these interfaces? Are they by chance
available via information_schema?
-FG
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
