Re: permission problems

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Ron Ellingson <rellingson(at)satshot(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: permission problems
Date: 2005-02-24 09:22:22
Message-ID: 421D9CCE.6020300@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

> 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

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Zouari Fourat 2005-02-24 16:34:22 Encoding problems
Previous Message Martín Marqués 2005-02-23 20:42:34 Re: permission problems