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

Поиск
Список
Период
Сортировка
Искать
От
Joe Conway
Тема
Re: how to list privileges on the database object itself via SQL?
Дата
Msg-id
4bb118ef-23c6-46e1-3938-91b660ff6047@joeconway.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>
On 4/26/23 13:50, richard coleman wrote:
> Thanks for that.  It still seems rather weird that there isn't a more 
> straightforward way to get access to that information.

Does this help?

https://github.com/CrunchyData/crunchy_check_access

For some examples of use:
https://www.crunchydata.com/blog/postgresql-defaults-and-impact-on-security-part-1

-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com



В списке pgsql-admin по дате отправления
От: Wetmore, Matthew (CTR)
Дата:
От: richard coleman
Дата:
FAQ