Today it seems that the following rules governs the permissions of sequences:
SELECT - allow you to select * from seq_name;
INSERT - no effect
UPDATE - allows nextval, setval - and yes implicitly currval
DELETE - no effect
I suggest nextval is moved into the insert permission as this is quite natural - normally you only need to call nextval
whenyou insert a new value into a table. I think this issue is important because setting the sequence to a value lower
thanthe max value in a table will cause errors for other users.
Aasmund Midttun Godal
aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46