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

Поиск
Список
Период
Сортировка
От richard coleman
Тема Re: how to list privileges on the database object itself via SQL?
Дата
Msg-id CAGA3vBvjUiUb+O-UWYU8VNrrPrLrwz+KOg3zqwiWTAAkTChX_A@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?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: how to list privileges on the database object itself via SQL?  (MichaelDBA <MichaelDBA@sqlexec.com>)
Список pgsql-admin
Дерево обсуждения
Tom, 

Thanks, but no.  I am looking for the SQL statement.

I very rarely venture into psql, unless it's to run an SQL code block from the terminal.
Is there an SQL way to do this?

Thanks again, 
rik.

On Wed, Apr 26, 2023 at 12:40 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
richard coleman <rcoleman.ascentgl@gmail.com> writes:
> This might sound like a silly question, but how would I list the privileges
> the various roles have on the database objects themselves?

Perhaps you are looking for psql's \l command?  It's a bit
nonstandardly named (one would expect \d something)

                        regards, tom lane

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

Предыдущее
От: Erik Wienhold
Дата:
Сообщение: Re: how to list privileges on the database object itself via SQL?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: how to list privileges on the database object itself via SQL?