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
