| From: | Pawan Sharma <pawanpg0963(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | |
| Date: | 2019-05-29 08:03:54 |
| Message-ID: | CAKqG8NU1r86sbfk_4zey6Moj5n+VSs2k9P5RKM1_FTPqWSrJ-A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PegoraroF10 | 2019-05-29 11:52:38 | with and trigger |
| Previous Message | Tom K | 2019-05-29 01:59:33 | Re: psql: FATAL: the database system is starting up |