Обсуждение: GRANT problem ?

Hi

I get a error message when i do an INSERT in a table (Absence_jour)
containing a SERIAL field :

ERROR: absence_jour_id_seq.nextval: you don't have permissions to set
sequence absence_jour_id_seq

It fails (with PSQL and ODBC) when i connect as a simple user (gddtest), but
i granted all privileges on the table for him
with the command GRANT ALL PRIVILEGES ON Absence_jour TO gddtest  !
It works when i connect as a superuser (the user who created the table).

Hints (maybe) : PostgreSQL 7.2 compiled on AIX 4.2 with GCC 2.95.2

Thanks

Eric GRIMOIS
Analyste programmeur
SEI - CPAM du Val d'Oise

try :
grant all on absence_jour_id_seq TO gddtest ;

http://www.pgexplorer.com
GUI Postgesql Tool


----- Original Message -----
From: "GRIMOIS Eric" <eric.grimois@cpam-cergypontoise.cnamts.fr>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, March 12, 2002 12:16 PM
Subject: [SQL] GRANT problem ?


> Hi
>
> I get a error message when i do an INSERT in a table (Absence_jour)
> containing a SERIAL field :
>
> ERROR: absence_jour_id_seq.nextval: you don't have permissions to set
> sequence absence_jour_id_seq
>
> It fails (with PSQL and ODBC) when i connect as a simple user (gddtest),
but
> i granted all privileges on the table for him
> with the command GRANT ALL PRIVILEGES ON Absence_jour TO gddtest  !
> It works when i connect as a superuser (the user who created the table).
>
> Hints (maybe) : PostgreSQL 7.2 compiled on AIX 4.2 with GCC 2.95.2
>
> Thanks
>
> Eric GRIMOIS
> Analyste programmeur
> SEI - CPAM du Val d'Oise
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

On March 12, 2002 05:16 am, GRIMOIS Eric wrote:
> I get a error message when i do an INSERT in a table (Absence_jour)
> containing a SERIAL field :
>
> ERROR: absence_jour_id_seq.nextval: you don't have permissions to set
> sequence absence_jour_id_seq

You have to grant permissions on the sequences separately from the table.  It
used to work as expected but at some point it changed for some reason.  It
certainly is inconvenient especially if you were used to the previous
behaviour and wrote all you local tools based on it.

You can get a list of all sequences with the "\ds" command in psql.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.