Re: How to display default privileges?

From: Vik Fearing <vik(at)2ndquadrant(dot)fr>
To: Marc Richter <mail(at)marc-richter(dot)info>, pgsql-novice(at)postgresql(dot)org
Subject: Re: How to display default privileges?
Date: 2016-09-05 13:29:39
Message-ID: 43f56115-64af-7c25-4a8b-e28886479590@2ndquadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Kiran 2016-09-10 10:23:13 Trigger is not working for Inserts from the application
Previous Message Marc Richter 2016-09-05 13:17:16 How to display default privileges?