Received: from kvikk.uit.no (kvikk.Uit.No [129.242.4.32]) by hub.org (8.9.1/8.9.1) with ESMTP id JAA18414 for ; Fri, 30 Oct 1998 09:40:23 -0500 (EST) (envelope-from pere@cc.uit.no) Received: from joseph.cc.uit.no (joseph.Cc.Uit.No [129.242.6.242]) by kvikk.uit.no (8.8.8/8.8.8) with ESMTP id PAA25892; Fri, 30 Oct 1998 15:40:12 +0100 (MET) Received: from zero.cc.uit.no (zero.Cc.Uit.No [129.242.7.34]) by joseph.cc.uit.no (8.8.8/8.8.8) with ESMTP id PAA04913; Fri, 30 Oct 1998 15:40:12 +0100 (MET) Received: (from pere@localhost) by zero.cc.uit.no (8.8.8/8.8.8) id PAA15232; Fri, 30 Oct 1998 15:40:11 +0100 (MET) Date: Fri, 30 Oct 1998 15:40:11 +0100 (MET) Message-Id: <199810301440.PAA15232@zero.cc.uit.no> To: pgsql-sql@postgresql.org Subject: Access rights to sequence.nextval? From: Petter Reinholdtsen Reply-to: pere@hungry.com I'm getting 'ERROR: invoice_seq.nextval: Permission denied.' when trying to get the next number from the sequence. It was made with my user, and user nobody tries to access it from PHP/Apache. The manual page says: > CREATE SEQUENCE will enter a new sequence number generator into the > current data base. This involves creating and initialising a new > single block table with the name seqname. The generator will be > "owned" by the user issuing the command. How do I change the access rights for this sequence, or how do I change ownership. Could it be something else that is wrong with this? I'm trying to access the sequence from perl. I've tried to change access rights with 'GRANT', but the change does not show up when I use '\z' in psql. If fact, the sequences are missing from the list. BTW: Please send copy of replies to my address, as I don't follow this list. -- ##> Petter Reinholdtsen <## | pere@td.org.uit.no O- http://www.hungry.com/~pere/ | Go Mozilla, go! Go!