From: | Gustavo Rosso <grosso(at)sadaic(dot)org(dot)ar> |
---|---|
To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Urgent - Grant |
Date: | 2008-11-18 14:46:07 |
Message-ID: | 4922D52F.4030705@sadaic.org.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andreas, my version is:
select version();
PostgreSQL 7.4 informix1.8 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
Is it old version?
Can to be the reason for my problem?
A. Kretschmer escribió:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Erwin Moller | 2008-11-18 14:47:04 | Foreign Key 'walker'? |
Previous Message | DANG Trieu | 2008-11-18 14:39:38 | Slow queries when ORDER BY ... DESC with table inheritance (no index scan backwards) |