X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 141C354E09 for ; Thu, 24 Feb 2005 09:24:14 +0000 (GMT) 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 52344-04 for ; Thu, 24 Feb 2005 09:24:05 +0000 (GMT) Received: from server.cityscape3d.com (unknown [217.206.144.18]) by svr1.postgresql.org (Postfix) with ESMTP id E380A53C92 for ; Thu, 24 Feb 2005 09:24:03 +0000 (GMT) Received: from mr101 ([192.168.1.110]) by server.cityscape3d.com (8.12.11/8.11.6) with ESMTP id j1O9NLgI048972; Thu, 24 Feb 2005 09:23:22 GMT (envelope-from chriskl@familyhealth.com.au) Received: from 127.0.0.1 (AVG SMTP 7.0.306 [266.4.0]); Thu, 24 Feb 2005 09:22:22 +0000 Message-ID: <421D9CCE.6020300@familyhealth.com.au> Date: Thu, 24 Feb 2005 09:22:22 +0000 From: Christopher Kings-Lynne User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Ron Ellingson Cc: pgsql-php@postgresql.org Subject: Re: permission problems References: <1109190257.23187.5.camel@vesuvius.fargo-office.satshot.com> In-Reply-To: <1109190257.23187.5.camel@vesuvius.fargo-office.satshot.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.012 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/27 X-Sequence-Number: 3001 > I am having a problem adding a row to a postgresql table with a sequence > as a primary key using pg_query. I receive an error, "permission denied > for sequence mytable_tid_seq". I have set the permissions for the user > from all which did not work to insert, update and select which did not > work. Can you help. Thanks GRANT SELECT, UPDATE ON sequence mytable_tid_seq TO ...; Chris