Sequence privileges

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Sequence privileges
Date: 2002-05-18 15:45:39
Message-ID: Pine.LNX.4.44.0205181720310.4819-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The documentation of the sequence privileges on the GRANT reference page
doesn't match the code.

Documented:

currval: UPDATE
nextval: UPDATE
setval: UPDATE

Actual:

currval: SELECT
nextval: UPDATE
setval: UPDATE

But shouldn't it more ideally be

currval: SELECT
nextval: SELECT + UPDATE
setval: UPDATE

because nextval allows you to infer the content of the sequence? (Cf.
UPDATE tab1 SET a = b requires SELECT + UPDATE on tab1.)

--
Peter Eisentraut peter_e(at)gmx(dot)net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-05-18 15:46:33 Re: Poster(s) needed
Previous Message Tom Lane 2002-05-18 15:22:35 Re: Updated CREATE FUNCTION syntax