Re: Default permissisons from schemas

On Jan 23, 2007, at 12:07 PM, Stephen Frost wrote:
>> Whoa.  You are going to allow people to create objects owned by  
>> someone
>> else?  I don't think so ... most Unix systems have forbidden object
>> give-away for years, for very good reasons.
>
> Hmm.  While I agree with the sentiment, Unix does provide for setgid
> such that objects inherit a specific group on creation.  Using  
> roles we
> don't get that distinction so I don't think comparing it to Unix is a
> slam-dunk.  There do need to be limitations here though, certainly.  A
> couple options, in order of my preference:

Is there a use-case for per-schema default ownership? I can't really  
think of one...
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)