schema privilege question

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: schema privilege question
Date: 2007-11-02 22:38:50
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C03062D5D@egcrc-ex01.egcrc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gallo(dot)ucsf(dot)edu

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Milen A. Radev 2007-11-03 00:18:48 Re: schema privilege question
Previous Message Alexander Lohse 2007-11-02 22:11:07 Problems with missing OIDs