pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
schema privilege question
3+ messages / 2 participants
[nested] [flat]

* schema privilege question
@ 2007-11-02 22:38 Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-11-03 00:18 ` Re: schema privilege question Milen A. Radev <milen@radev.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Tena Sakai @ 2007-11-02 22:38 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: schema privilege question
  2007-11-02 22:38 schema privilege question Tena Sakai <tsakai@gallo.ucsf.edu>
@ 2007-11-03 00:18 ` Milen A. Radev <milen@radev.net>
  2007-11-03 00:29   ` Re: schema privilege question Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 1 reply; 3+ messages in thread

From: Milen A. Radev @ 2007-11-03 00:18 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: schema privilege question
  2007-11-02 22:38 schema privilege question Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-11-03 00:18 ` Re: schema privilege question Milen A. Radev <milen@radev.net>
@ 2007-11-03 00:29   ` Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 0 replies; 3+ messages in thread

From: Tena Sakai @ 2007-11-03 00:29 UTC (permalink / raw)
  To: Milen A. Radev <milen@radev.net>; pgsql-admin

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/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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-11-03 00:29 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-02 22:38 schema privilege question Tena Sakai <tsakai@gallo.ucsf.edu>
2007-11-03 00:18 ` Milen A. Radev <milen@radev.net>
2007-11-03 00:29   ` Tena Sakai <tsakai@gallo.ucsf.edu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox