- Mailing list pgsql-general

From Pawan Sharma
Subject
Date
Msg-id CAKqG8NU1r86sbfk_4zey6Moj5n+VSs2k9P5RKM1_FTPqWSrJ-A@mail.gmail.com
Whole thread Raw
Responses Re:
List pgsql-general
Hello All,

Is it possible check privileges of all the users or roles, and what are the objects owned by user and role with their privileges.

I am getting the output which want from information_schema.roles_usage_grants, but as I not running the query as a superuser so I am able to see only one specific user results but I want all user and roles details.

Is there specific privileges which I can grant to that user to get the complete results apart from superuser privilege.


Thanks in advance
Regards,
Pawan

pgsql-general by date:

Previous
From: Tom K
Date:
Subject: Re: psql: FATAL: the database system is starting up
Next
From: PegoraroF10
Date:
Subject: with and trigger