SEO

#1 (**permalink**) 04-10-2008, 08:17 AM

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?

Thank you in advance.

Tena Sakai
tsakai@gallo.ucsf.edu

#2 (**permalink**) 04-10-2008, 08:17 AM

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/curre...l-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

#3 (**permalink**) 04-10-2008, 08:17 AM

Many thanks, Milen.

Tena

-----Original Message-----
From: pgsql-admin-owner@postgresql.org 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/curre...l-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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode