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: [email protected] [mailto:[email protected]] On Behalf Of Stephen Frost Sent: Thursday, March 24, 2011 4:56 PM To: Yang Zhang Cc: [email protected] Subject: Re: [GENERAL] Default permissions for CREATE SCHEMA/TABLE? * Yang Zhang ([email protected]) 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
