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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
