Sequences and privileges

The privileges to create, alter, drop, select, and update sequences are as follows:

The admin user has all privileges on all user sequences. There is no need to grant any privileges to the admin user.
The owner of the database or schema where the sequence is defined has full privileges on all user sequences in that database or schema. There is no need to grant any privileges to the owner.

The following table lists the privileges that you must grant for all other users.

Table 1. Sequence privileges
Command	Privileges
CREATE SEQUENCE	Create Sequence administration permission
ALTER SEQUENCE	Alter object privilege for a specific sequence or the Sequence object class
DROP SEQUENCE	Drop object privilege for a specific sequence or the Sequence object class
NEXT VALUE FOR SEQUENCE	Update object privilege for a specific sequence or the Sequence object class For example, `SELECT NEXT VALUE FOR <sequence name>`.