Urgent - Grant

Started by Gustavo Rossoover 17 years ago1 messagesgeneral
Jump to latest
#1Gustavo Rosso
grosso@sadaic.org.ar

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