Sequence permission suggestion

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