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 [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings