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: 20040129150520.GA6865@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2004-01-29 15:10:56 Re: Grant question
Previous Message Barbara Lindsey 2004-01-29 15:03:49 Re: Grant question