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

Re: Grant question

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Barbara Lindsey <blindsey(at)cog(dot)ufl(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Grant question
Date: 2004-01-29 15:05:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Thu, Jan 29, 2004 at 09:52:56 -0500,
  Barbara Lindsey <blindsey(at)cog(dot)ufl(dot)edu> wrote:
> What kind of grant do you need to give a user so that they can have 
> permission to do a "SELECT nextval(ID)" on a sequence?
> I granted the user SELECT,UPDATE,INSERT,DELETE on all the tables, 
> including the one that has the sequence, but the sequence query is 
> failing on permissions.

Sequences have permissions separate from tables. I believe you need
update access to call nextval or setval on a sequence. This should
be described in the documention on the GRANT command.

In response to


pgsql-general by date

Next:From: John Sidney-WoollettDate: 2004-01-29 15:10:56
Subject: Re: Grant question
Previous:From: Barbara LindseyDate: 2004-01-29 15:03:49
Subject: Re: Grant question

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