Re: Default privileges for new databases (was Re: Can't - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: Default privileges for new databases (was Re: Can't
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961E65@m0114.s-mxs.net
Whole thread Raw
Responses Re: Default privileges for new databases (was Re: Can't  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> What we really need is some mode on template1 that says, "I am not
> world-writable, but the admin hasn't made me world-non-writable, so I
> will create new databases that are world-writable".  Does that make
> sense?

I think template1 public should be non-world-writeable by default, and pass that
to newly created databases. What exactly was it, why we don't want that ?
Backwards compatibility ? Imho doing one (additional) grant after creating a db
cannot be such a problem, no ?

Andreas


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: REINDEX ALL and CLUSTER ALL
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: MemoryContextAlloc: invalid request size 1934906735