Обсуждение: How to display default privileges?

Поиск
Список
Период
Сортировка

How to display default privileges?

От
Marc Richter
Дата:
Hi everyone,

from what I know, since PostgreSQL 9.0 it is supported to change default
privileges for newly created tables, functions and sequences by using
"ALTER DEFAULT PRIVILEGES".

How to display the current settings?

Best regards,
Marc

Re: How to display default privileges?

От
Vik Fearing
Дата:
On 09/05/2016 03:17 PM, Marc Richter wrote:
> Hi everyone,
>
> from what I know, since PostgreSQL 9.0 it is supported to change default
> privileges for newly created tables, functions and sequences by using
> "ALTER DEFAULT PRIVILEGES".
>
> How to display the current settings?

You can use psql's \ddp, or look in pg_default_acl directly.
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support