Keep in mind if you want to alter the GLOBAL privileges (i.e., the defaults) granted via PUBLIC you MUST NOT specify a schema. >From what I can tell there is no way to associate a default owner different that the one executing the CREATE statement (though some inheritance cases do arise IIRC). David J. -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Stephen Frost Sent: Thursday, March 24, 2011 4:56 PM To: Yang Zhang Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Default permissions for CREATE SCHEMA/TABLE? * Yang Zhang (yanghatespam@xxxxxxxxx) 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. ALTER DEFAULT PRIVILEGES FOR ROLE my_user IN SCHEMA my_schema GRANT SELECT ON TABLES TO other_role; http://www.postgresql.org/docs/9.0/static/sql-alterdefaultprivileges.html Thanks, Stephen -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
