how to list privileges on the database object itself via SQL?

Поиск
Список
Период
Сортировка
От richard coleman
Тема how to list privileges on the database object itself via SQL?
Дата
Msg-id CAGA3vBvanu7UBtaaVv9PH25Ko==5F2wewhPWTTra8wqexdDAdQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to list privileges on the database object itself via SQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: how to list privileges on the database object itself via SQL?  (Erik Wienhold <ewie@ewie.name>)
Re: how to list privileges on the database object itself via SQL?  (jian he <jian.universality@gmail.com>)
Список pgsql-admin
All, 

This might sound like a silly question, but how would I list the privileges the various roles have on the database objects themselves?

There appear to be a million ways to list the privileges on various database objects; tables, views, foreign tables, etc.  but for the life of me there doesn't appear to an analogous way to get permissions on the database objects themselves.

At the moment all that I've found is:

select has_database_privilege('role','db_name', 'CREATE') as can_create;
select has_database_privilege('role','db_name', 'CONNECT') as can_connect;
select has_database_privilege('role','db_name', 'TEMP') as can_temp;
 
Am I missing something?

Thanks, 
rik.

В списке pgsql-admin по дате отправления:

Предыдущее
От: fatih abztn
Дата:
Сообщение: pgBouncer - got packet 'D' from server when not linked WARNING messages
Следующее
От: Tom Lane
Дата:
Сообщение: Re: how to list privileges on the database object itself via SQL?