Re: permission problems - Mailing list pgsql-php

From Christopher Kings-Lynne
Subject Re: permission problems
Date
Msg-id 421D9CCE.6020300@familyhealth.com.au
Whole thread Raw
In response to permission problems  (Ron Ellingson <rellingson@satshot.com>)
List 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

pgsql-php by date:

Previous
From: Martín Marqués
Date:
Subject: Re: permission problems
Next
From: Zouari Fourat
Date:
Subject: Encoding problems