pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
permission 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