Received: from mars.linutech.co.za (bnb53-01-101.nt.saix.net [155.239.181.101]) by postgresql.org (Postfix) with ESMTP id 0B820475932 for ; Tue, 12 Mar 2002 06:57:28 -0500 (EST) Received: from edios (edios.linutech.co.za [192.168.250.5]) by mars.linutech.co.za (8.11.0/8.11.0) with SMTP id g2CBvIA14222; Tue, 12 Mar 2002 13:57:18 +0200 Message-ID: <000901c1c9bd$2b8d7fa0$05faa8c0@edios> From: "PGMailList" To: "GRIMOIS Eric" , References: <000b01c1c9ae$f3a42d40$3d04a837@PXXXX> Subject: Re: GRANT problem ? Date: Tue, 12 Mar 2002 13:58:05 +0200 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.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200203/115 X-Sequence-Number: 6996 try : grant all on absence_jour_id_seq TO gddtest ; http://www.pgexplorer.com GUI Postgesql Tool ----- Original Message ----- From: "GRIMOIS Eric" To: 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 >