PGSQL: listing db/role and user/role relationships

[Felipe Gasper <felipe@xxxxxxxxxxxxxxxx>]

Hi all,

	How can I retrieve:


1) each role’s privileges on a given DB

For example, if I do: “GRANT ALL PRIVILEGES ON DATABASE thedb TO 
therole”, how can I list this grant among others with access to “thedb”?


2) which users have access to a given role

For example, if I do: “GRANT therole TO theuser”, how can I list all of 
the users that can take on “therole”?


3) which roles a given user can access

For example, if I do: “GRANT therole TO theuser”, how can I list all of 
the roles that “theuser” can take on?


Thanks!


-Felipe Gasper
Houston, TX, USA


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general