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

From Thomas Swan
Subject Re: inconsistent owners in newly created databases?
Date
Msg-id 40967778.2060507@idigx.com
Whole thread Raw
In response to Re: inconsistent owners in newly created databases?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

>Thomas Swan <tswan@idigx.com> writes:
>  
>
>>Fabien COELHO wrote:
>>    
>>
>>>You don't want to update ownership of tables in system schemas.
>>>
>>>      
>>>
>>AFAICS, any changes they make are localized to their database not the 
>>whole database system.
>>    
>>
>
>A database owner who is not a superuser should *not* be able to fool with
>the built-in catalog entries.
>
>Database owner != superuser, and I don't want us blurring the distinction...
>
>  
>
With regards to changing ownership, is there a way to determine what is 
a "built-in" catalog entry?  If the database that was the template was 
modified, can the createdb routine determine what is core and what was 
added?


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Weird prepared stmt behavior
Next
From: Fabien COELHO
Date:
Subject: Re: inconsistent owners in newly created databases?