Change built-in default privileges for CREATE DATABASE?

From: Michał Rus <m(at)michalrus(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Change built-in default privileges for CREATE DATABASE?
Date: 2013-05-30 10:24:08
Message-ID: CAH=q+8LtTyiX3yD3ysKWcU-aqCrOo0Y_EYB7F7Jm_Ew7Zhi4+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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ł.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Armand du Plessis 2013-05-30 10:24:33 Re: Least intrusive way to move primary data
Previous Message Andrew W. Gibbs 2013-05-30 10:19:16 Re: Least intrusive way to move primary data