On Sun, Apr 28, 2013 at 9:39 PM, Josh Berkus <[email protected]> wrote: >> The fine manual notes that the target role has to already have CREATE >> privileges on the target schema --- maybe that's what's biting you in >> this case? > > Nope. That was the first thing I thought of. It really is that the > target role must *own* the schema. So clearly a bug.
wfm. rhaas=# create user bob; CREATE ROLE rhaas=# create schema we_like_bob; CREATE SCHEMA rhaas=# alter default privileges for role bob in schema we_like_bob grant select on tables to bob; ERROR: permission denied for schema we_like_bob rhaas=# grant create on schema we_like_bob to bob; GRANT rhaas=# alter default privileges for role bob in schema we_like_bob grant select on tables to bob; ALTER DEFAULT PRIVILEGES -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
