Re: Seeing privileges on a schema

Поиск
Список
Период
Сортировка
От John Scalia
Тема Re: Seeing privileges on a schema
Дата
Msg-id 575F6ED5-BDE7-4944-94F0-F32CDC735C15@gmail.com
обсуждение исходный текст
Ответ на Re: Seeing privileges on a schema  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Thanks, I didn’t realize that.

Sent from my iPad

> On Dec 2, 2020, at 2:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> John Scalia <jayknowsunix@gmail.com> writes:
>> In psql, I know that \dp or \dpp will show me which privileges are granted on tables, views, sequences, and
functions,what it doesn’t appear to be able to do, is show me what privileges are in the schema itself, like if I grant
usageon a schema. Then a \dpp doesn’t produce anything. Is there an easy way to see what privileges are on a schema? 
>
> \dn+ includes that.
>
>            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Seeing privileges on a schema
Следующее
От: Rob Emery
Дата:
Сообщение: Re: pg_upgrade + replica servers + rsync --size-only is unsafe