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   [EMAIL PROTECTED]


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to