On Thu, Apr 21, 2005 at 03:50:04PM -0600, Walker, Jed S wrote:
> 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).
vrngui is probably trying to execute nextval('seq_page'). SELECT
privilege on a sequence allows currval(), but nextval() requires
UPDATE privilege. Try this:
GRANT SELECT, UPDATE ON seq_page TO GROUP vrn_admin;
For more information, see the documentation for GRANT:
In response to
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2005-04-22 00:17:53|
|Subject: Re: lo_creat SQL command|
|Previous:||From: Walker, Jed S||Date: 2005-04-21 21:50:04|
|Subject: Granting permission on a sequence to a group|