pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
GRANT problem ?
3+ messages / 3 participants
[nested] [flat]

* GRANT problem ?
@ 2002-03-12 10:16  GRIMOIS Eric <eric.grimois@cpam-cergypontoise.cnamts.fr>
  0 siblings, 2 replies; 3+ messages in thread

From: GRIMOIS Eric @ 2002-03-12 10:16 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: GRANT problem ?
@ 2002-03-12 11:58  PGMailList <pgmail@pgexplorer.com>
  parent: GRIMOIS Eric <eric.grimois@cpam-cergypontoise.cnamts.fr>
  1 sibling, 0 replies; 3+ messages in thread

From: PGMailList @ 2002-03-12 11:58 UTC (permalink / raw)
  To: GRIMOIS Eric <eric.grimois@cpam-cergypontoise.cnamts.fr>; pgsql-sql

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
>




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: GRANT problem ?
@ 2002-03-12 11:59  D'Arcy J.M. Cain <darcy@druid.net>
  parent: GRIMOIS Eric <eric.grimois@cpam-cergypontoise.cnamts.fr>
  1 sibling, 0 replies; 3+ messages in thread

From: D'Arcy J.M. Cain @ 2002-03-12 11:59 UTC (permalink / raw)
  To: GRIMOIS Eric <eric.grimois@cpam-cergypontoise.cnamts.fr>; +Cc: pgsql-sql

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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2002-03-12 11:59 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-12 10:16 GRANT problem ? GRIMOIS Eric <eric.grimois@cpam-cergypontoise.cnamts.fr>
2002-03-12 11:58 ` PGMailList <pgmail@pgexplorer.com>
2002-03-12 11:59 ` D'Arcy J.M. Cain <darcy@druid.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox