On Thursday, March 24, 2011 1:52:24 pm Yang Zhang wrote: > Any way I can have all newly created schemas/tables be owned by, or > have all permissions granted to, a certain group, without having to > remember to GRANT ALL ON [SCHEMA|TABLE] TO that group? Thanks in > advance. If you are using 9.0: http://www.postgresql.org/docs/9.0/interactive/sql-alterdefaultprivileges.html -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general