Re: Default permissisons from schemas - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Default permissisons from schemas
Date
Msg-id 1FF2D97D-7CED-41E7-8996-CEA2CD4DDA95@decibel.org
Whole thread Raw
In response to Re: Default permissisons from schemas  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Default permissisons from schemas
List pgsql-hackers
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)




pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [GENERAL] Autovacuum Improvements
Next
From: Jim Nasby
Date:
Subject: Re: About PostgreSQL certification