X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F29E2528E7 for ; Fri, 3 Jun 2005 16:15:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71275-04 for ; Fri, 3 Jun 2005 19:15:55 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 853E3528CD for ; Fri, 3 Jun 2005 16:15:55 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j53JFtoU073913 for ; Fri, 3 Jun 2005 19:15:55 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j53IoKhC061231 for pgsql-admin@postgresql.org; Fri, 3 Jun 2005 18:50:20 GMT (envelope-from news) From: woody X-Newsgroups: pgsql.admin Subject: Re: unable to GRANT on sequence Date: Fri, 3 Jun 2005 11:26:29 -0500 Organization: Database Forum Lines: 22 Message-ID: X-Complaints-To: usenet@news.hub.org User-Agent: droptable.com news gateway X-Newsreader: droptable.com news gateway X-Originating-IP: 208.24.179.207 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/18 X-Sequence-Number: 17773 I'm having trouble GRANTing access on sequences. I created a database called 'asterisk' using the 'postgres' user. I then created 2 users called 'asterisk' and 'asterisk_owner'. I created a schema called 'asterisk' and GRANTed CREATE, DROP, INSERT, UPDATE, DELETE on this schema to 'asterisk_owner'. I signed in as 'asterisk_owner' and created some tables with primary keys based on sequences, then GRANTed SELECT, UPDATE, INSERT, DELETE on these tables to 'asterisk'. When I log in as 'asterisk', I can insert rows but I can't use the implied nextval(). It says the relation does not exist. When I do a \dp, I can see the sequence objects listed, but no permissions are listed. The tables have all the expected permissions. I couldn't see anything in the reference for the GRANT command for sequences. -- woody ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------