pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedpermission problems
4+ messages / 4 participants
[nested] [flat]
* permission problems
@ 2005-02-23 20:24 Ron Ellingson <rellingson@satshot.com>
2005-02-23 20:39 ` Re: permission problems Heather Johnson <hjohnson@nypost.com>
2005-02-23 20:42 ` Re: permission problems Martín Marqués <martin@bugs.unl.edu.ar>
2005-02-24 09:22 ` Re: permission problems Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 3 replies; 4+ messages in thread
From: Ron Ellingson @ 2005-02-23 20:24 UTC (permalink / raw)
To: 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
Ron Ellingson
rellingson@satshot.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: permission problems
2005-02-23 20:24 permission problems Ron Ellingson <rellingson@satshot.com>
@ 2005-02-23 20:39 ` Heather Johnson <hjohnson@nypost.com>
2 siblings, 0 replies; 4+ messages in thread
From: Heather Johnson @ 2005-02-23 20:39 UTC (permalink / raw)
To: Ron Ellingson <rellingson@satshot.com>; +Cc: pgsql-php
Did you grant the relevant permissions on just the table, or on both the
sequence and the table? You'll need to do both.
Heather Johnson
Senior Database Programmer
New York Post
Ron Ellingson wrote:
> 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
>
> Ron Ellingson
> rellingson@satshot.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: permission problems
2005-02-23 20:24 permission problems Ron Ellingson <rellingson@satshot.com>
@ 2005-02-23 20:42 ` Martín Marqués <martin@bugs.unl.edu.ar>
2 siblings, 0 replies; 4+ messages in thread
From: Martín Marqués @ 2005-02-23 20:42 UTC (permalink / raw)
To: Ron Ellingson <rellingson@satshot.com>; +Cc: pgsql-php
El Mié 23 Feb 2005 17:24, Ron Ellingson escribió:
> 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
Did you check the permissions of the sequence?
--
17:40:04 up 164 days, 7:34, 3 users, load average: 1.43, 1.36, 0.97
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: permission problems
2005-02-23 20:24 permission problems Ron Ellingson <rellingson@satshot.com>
@ 2005-02-24 09:22 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2 siblings, 0 replies; 4+ messages in thread
From: Christopher Kings-Lynne @ 2005-02-24 09:22 UTC (permalink / raw)
To: Ron Ellingson <rellingson@satshot.com>; +Cc: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-02-24 09:22 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-23 20:24 permission problems Ron Ellingson <rellingson@satshot.com>
2005-02-23 20:39 ` Heather Johnson <hjohnson@nypost.com>
2005-02-23 20:42 ` Martín Marqués <martin@bugs.unl.edu.ar>
2005-02-24 09:22 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox