0

I have seen postgresql allowing users to Grant update on a sequence. But never seen any update query on the sequence. Sequence values are usually changed using ALTER SEQUENCE command. I understand the need for GRANT USAGE and GRANT SELECT on sequences. But what exactly does a GRANT UPDATE on a sequence lets you do in PostgreSQL.

1 Answer 1

0

The documentation says:

nextval ( regclass )bigint

[...]
This function requires USAGE or UPDATE privilege on the sequence.


setval ( regclass, bigint [, boolean ] )bigint

[...]
This function requires UPDATE privilege on the sequence.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.