- Архив списков рассылки pgsql-general

Поиск
Список
Период
Сортировка
От Pawan Sharma
Тема
Дата
Msg-id CAKqG8NU1r86sbfk_4zey6Moj5n+VSs2k9P5RKM1_FTPqWSrJ-A@mail.gmail.com
обсуждение исходный текст
Ответы Re:  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom K
Дата:
Сообщение: Re: psql: FATAL: the database system is starting up
Следующее
От: PegoraroF10
Дата:
Сообщение: with and trigger