Jeff Davis <pg...@j-davis.com> writes: > On Mon, 2009-06-29 at 10:52 -0700, Josh Berkus wrote: >> 1) ALTER SCHEMA SET DEFAULT PRIVILEGES statements which sets default >> permissions, by ROLE and object type, on new objects. >> >> 2) a statement to set privs on all existing objects by type and role >> within a schema.
> I don't see why either of these things should be properties of the > schema. It seems to make much more sense for these defaults to be a > property of the user who creates the objects. That seems fairly backwards to me. I agree that tying it to schemas is a bit less flexible than one could wish, but that doesn't make attaching it to the user the right thing. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers