Skip site navigation (1) Skip section navigation (2)

Re: Granting permission on a sequence to a group

From: "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>
To: "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>,"'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Granting permission on a sequence to a group
Date: 2005-04-22 14:21:14
Message-ID: 41669DC6FE3B80449A33A4DD46DB370A09E7EAF3@entcoexch15.broadband.att.com (view raw or flat)
Thread:
Lists: pgsql-novice
I found a note in a book that states that using "nextval" can't be done with
only select privileges, but it doesn't say what else is needed. Can someone
tell me (hopefully I find it eventually)?

> _____________________________________________ 
> From: 	Walker, Jed S  
> Sent:	Thursday, April 21, 2005 3:50 PM
> To:	'pgsql-novice(at)postgresql(dot)org'
> Subject:	Granting permission on a sequence to a group
> 
> Hi,
> 
> I have a sequence seq_page owned by user vrnsys. Vrnsys has granted
> "select" on seq_page to group vrn_admin. vrn_admin group has had user
> vrngui added to it, but vrngui is not able to access the sequence
> (permission denied for sequence seq_page).
> 
> 1. Any ideas why this isn't working?
> 
> Thanks in advance,
> 
> 	Jed S. Walker 
> 
> 
> 

pgsql-novice by date

Next:From: Walker, Jed SDate: 2005-04-22 14:23:04
Subject: Authorized privileges when calling a procedure
Previous:From: Frank BaxDate: 2005-04-22 13:26:36
Subject: Re: Disk full problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group