Postgres Pro
Downloads
Home   >   mailing lists

Change built-in default privileges for CREATE DATABASE? - Mailing list pgsql-admin

From Michał Rus
Subject Change built-in default privileges for CREATE DATABASE?
Date
Msg-id CAH=q+8LtTyiX3yD3ysKWcU-aqCrOo0Y_EYB7F7Jm_Ew7Zhi4+Q@mail.gmail.com
Whole thread Raw
Responses Re: Change built-in default privileges for CREATE DATABASE?
List pgsql-admin
Tree view 
Hello,

when i CREATE a new DATABASE, its privileges column is empty (it's not
the same case as it being '{}', which means no privileges). Empty
column means: use built-in defaults. These defaults are:

=c + owner=CTc

How can I change these defaults so that after creation PUBLIC gets no
rights? That is: remove '=c' from them.

Here's a more detailed post on dba.SE:

http://dba.stackexchange.com/questions/43387/change-built-in-default-privileges-in-postgresql

Thanks,
Michał.

pgsql-admin by date:

Previous
From: "Andrew W. Gibbs"
Date:
Subject: Re: Least intrusive way to move primary data
Next
From: Armand du Plessis
Date:
Subject: Re: Least intrusive way to move primary data