From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Urgent - Grant |
Date: | 2008-11-18 13:33:12 |
Message-ID: | 20081118133312.GG19076@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
am Tue, dem 18.11.2008, um 11:25:16 -0300 mailte Gustavo Rosso folgendes:
> 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=>
Which version?
Apparently very old, since OID are deprecated for a long time.
I can't reproduce your problem:
test=# create user foo;
CREATE ROLE
test=# GRANT ALL ON DATABASE test to public;
GRANT
test=# GRANT CREATE ON DATABASE test to public;
GRANT
test=# \q
kretschmer(at)apache-new:~$ psql-dev -U foo test
psql (8.4devel)
Type "help" for help.
test=> select current_user;
current_user
--------------
foo
(1 row)
test=> create table tabla (x integer);
CREATE TABLE
test=> create table tablb (x integer primary key);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"tablb_pkey" for table "tablb"
CREATE TABLE
test=>
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
From | Date | Subject | |
---|---|---|---|
Next Message | Grzegorz Jaśkiewicz | 2008-11-18 13:37:10 | Re: strange commit behavior |
Previous Message | Craig Ringer | 2008-11-18 13:25:30 | Re: strange commit behavior |