Обсуждение: Which GRANTS are needed on a Sequnce?

Hi all,
I just created a Sequence S for User A.
User B has the USAGE Privilage in Schema A.
I granted SELECT On S TO B.
But this does not seem to be enough to use the Sequcence,
postgres claims:
 [1] ERROR:  S.nextval: you don't have permissions to set sequence S
So I granted ALL ON S TO B
which works fine.
What are the minimal grants neeeded? (And where is it documented,
the reference of 7.3.3 sais nothing about Sequences)

Cheers,
Dani

On Fri, Jun 27, 2003 at 16:43:49 +0200,
  Dani Oderbolz <oderbolz@ecologic.de> wrote:
> Hi all,
> I just created a Sequence S for User A.
> User B has the USAGE Privilage in Schema A.
> I granted SELECT On S TO B.
> But this does not seem to be enough to use the Sequcence,
> postgres claims:
> [1] ERROR:  S.nextval: you don't have permissions to set sequence S
> So I granted ALL ON S TO B
> which works fine.
> What are the minimal grants neeeded? (And where is it documented,
> the reference of 7.3.3 sais nothing about Sequences)

You need to grant update access to the sequence.
This is documented at:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-grant.html
Look under what access is granted by update.

Dani Oderbolz <oderbolz@ecologic.de> writes:
> What are the minimal grants neeeded? (And where is it documented,
> the reference of 7.3.3 sais nothing about Sequences)

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-grant.html

SELECT and UPDATE rights apply to sequences in about the way you'd
expect (read and write privilege, respectively).

            regards, tom lane