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
Список
Дерево обсуждения
how to list privileges on the database object itself via SQL? richard coleman <rcoleman.ascentgl@gmail.com>
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? richard coleman <rcoleman.ascentgl@gmail.com>
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? Holger Jakobs <holger@jakobs.com>
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? richard coleman <rcoleman.ascentgl@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? richard coleman <rcoleman.ascentgl@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? richard coleman <rcoleman.ascentgl@gmail.com>
how to list privileges on the database object itself via SQL? "Wetmore, Matthew (CTR)" <Matthew.Wetmore@express-scripts.com>
Re: how to list privileges on the database object itself via SQL? richard coleman <rcoleman.ascentgl@gmail.com>
how to list privileges on the database object itself via SQL? "Wetmore, Matthew (CTR)" <Matthew.Wetmore@express-scripts.com>
Re: how to list privileges on the database object itself via SQL? Inzamam Shafiq <inzamam.shafiq@hotmail.com>
Re: how to list privileges on the database object itself via SQL? richard coleman <rcoleman.ascentgl@gmail.com>
Re: how to list privileges on the database object itself via SQL? Joe Conway <mail@joeconway.com>
Re: how to list privileges on the database object itself via SQL? Laurenz Albe <laurenz.albe@cybertec.at>
Re: how to list privileges on the database object itself via SQL? Holger Jakobs <holger@jakobs.com>
Re: how to list privileges on the database object itself via SQL? richard coleman <rcoleman.ascentgl@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? richard coleman <rcoleman.ascentgl@gmail.com>
Re: how to list privileges on the database object itself via SQL? Holger Jakobs <holger@jakobs.com>
Re: how to list privileges on the database object itself via SQL? MichaelDBA <MichaelDBA@sqlexec.com>
Re: how to list privileges on the database object itself via SQL? richard coleman <rcoleman.ascentgl@gmail.com>
Re: how to list privileges on the database object itself via SQL? jian he <jian.universality@gmail.com>
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 по дате отправления
От: fatih abztn
Дата:
От: Tom Lane
Дата: