| 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
| 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 |