Re: inconsistent owners in newly created databases? - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: inconsistent owners in newly created databases?
Date
Msg-id Pine.LNX.4.58.0405051759540.9381@sablons.cri.ensmp.fr
Whole thread Raw
In response to Re: inconsistent owners in newly created databases?  (Greg Stark <gsstark@mit.edu>)
Responses Re: inconsistent owners in newly created databases?  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
> >       nspacl   = aclitems_switch_grantor(nspacl, datdba)
>
> Instead of having a hard coded list of template1 objects that need to be
> chowned to the database owner. Perhaps there should be a special user like
> dbowner which owns the schema and whatever other objects are necessary.
> [...]

I agree with the advantage.

But I'm uneasy to know what a special owner would be, pratically speaking.
If it would mean that everywhere in the source code where an owner is
manipulated, there must be some kind of special test for that case, I'm
not sure it would be that great...

Also any database can be used as a template, not just template1.
Moreover, template1 is a still usable database, that can be set with
whatever you want in new created, so it is not "that" special...

Well, that's grain for thoughts anyway;-)

Thanks, have a nice day,

-- 
Fabien Coelho - coelho@cri.ensmp.fr


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: inconsistent owners in newly created databases?
Next
From: Greg Stark
Date:
Subject: Re: inconsistent owners in newly created databases?