Many thanks, Milen. Tena
-----Original Message----- From: [EMAIL PROTECTED] on behalf of Milen A. Radev Sent: Fri 11/2/2007 5:18 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] schema privilege question Tena Sakai ??????: > Hi everybody, > > I just created a new schema. Like this: > > create schema newschema authorization foo; > > Now I want to 3 other uses besides foo to be > able to create and drop tables/views/etc. > What I want to do would be something like: > > grant create on newschema to x, y, z; > > But it disagrees with me as to: > ERROR: relation "newschema" does not exist > > How can I do what I want to do? Add "schema" to the statement (it's mandatory - http://www.postgresql.org/docs/current/static/sql-grant.html): grant create on SCHEMA newschema to x, y, z; -- Milen A. Radev ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
