Re: PGSQL: listing db/role and user/role relationships - Mailing list pgsql-general

On 17.11.13 2:56 AM, Luca Ferrari wrote:
> 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
>

Thank you!

One more question: how “stable” are these interfaces? Are they by chance
available via information_schema?

-FG