Postgres Pro
Downloads
Home   >   mailing lists

Re: How to display default privileges? - Mailing list pgsql-novice

From Vik Fearing
Subject Re: How to display default privileges?
Date
Msg-id 43f56115-64af-7c25-4a8b-e28886479590@2ndquadrant.fr
Whole thread Raw
In response to How to display default privileges?  (Marc Richter <mail@marc-richter.info>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Marc Richter
Date:
Subject: How to display default privileges?
Next
From: Kiran
Date:
Subject: Trigger is not working for Inserts from the application