Urgent - Grant

From: Gustavo Rosso <grosso(at)sadaic(dot)org(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: Urgent - Grant
Date: 2008-11-18 14:25:16
Message-ID: 4922D04C.5070209@sadaic.org.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

People of world, help help please.
I created a DB with super-user postgres, I give all privileges to DB
(banco is my DB)
GRANT ALL ON DATABASE banco TO PUBLIC;
GRANT CREATE ON DATABASE banco TO PUBLIC

But other users can't create tables in this DB
ERROR:
banco=> create table tabla (x integer);
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"tabla_oid_idx" for table "tabla"
*ERROR: must be owner of relation tabla*
banco=>

But they can use select,update,delete
What happen? What must to do?

Thanks, thanks...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DANG Trieu 2008-11-18 14:39:38 Slow queries when ORDER BY ... DESC with table inheritance (no index scan backwards)
Previous Message Grzegorz Jaśkiewicz 2008-11-18 13:37:10 Re: strange commit behavior