Postgres Pro
Downloads
Home   >   mailing lists

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

From Marc Richter
Subject How to display default privileges?
Date
Msg-id 1805d68f-d1d0-b3f3-e44f-01ded62c3a98@marc-richter.info
Whole thread Raw
Responses Re: How to display default privileges?
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Marc Richter
Date:
Subject: How to display ALL privileges for a role using SQL?
Next
From: Vik Fearing
Date:
Subject: Re: How to display default privileges?