On Sat, Nov 16, 2013 at 1:19 AM, Felipe Gasper <felipe@felipegasper.com> 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