Received: from smtpp.cnamts.fr (unknown [195.6.127.73]) by postgresql.org (Postfix) with SMTP id 7BC77474E49 for ; Tue, 12 Mar 2002 06:05:52 -0500 (EST) Received: from pivot.cnamts.fr ([127.0.0.1]) by pivot.NTCNAMTS (Netscape Messaging Server 3.5) with SMTP id 413 for ; Tue, 12 Mar 2002 11:51:47 +0100 Received: from PXXXX ([55.168.4.61]) by hermes1.cpam-cergypontoise.cnamts.fr (Netscape Messaging Server 3.5) with SMTP id 708 for ; Tue, 12 Mar 2002 11:24:18 +0100 Message-ID: <000b01c1c9ae$f3a42d40$3d04a837@PXXXX> From: "GRIMOIS Eric" To: Subject: GRANT problem ? Date: Tue, 12 Mar 2002 11:16:19 +0100 Organization: CPAM du Val d'Oise MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200203/114 X-Sequence-Number: 6995 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