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