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?
Re: how to list privileges on the database object itself via SQL? Re: how to list privileges on the database object itself via SQL? |
Список | 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;
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 по дате отправления: