Description

ALL or ALL PRIVILEGES
Revokes one or more sequence privileges from each authorization-name. The privileges revoked are those privileges on the identified sequences that were granted to the authorization-names. Note that revoking ALL PRIVILEGES on a sequence is not the same as revoking the system authority of *ALL.

If you do not use ALL, you must use one or more of the keywords listed below. Each keyword revokes the privilege described.

ALTER
Revokes the privilege to use the ALTER SEQUENCE, COMMENT, and LABEL statements on a sequence.
USAGE
Revokes the privilege to use the sequence in NEXT VALUE or PREVIOUS VALUE expressions.
ON SEQUENCE sequence-name
Identifies the sequences from which you are revoking privileges. The sequence-name must identify a sequence that exists at the current server.
FROM
Identifies from whom the privileges are revoked.
authorization-name,...
Lists one or more authorization IDs. Do not specify the same authorization-name more than once.
PUBLIC
Revokes the specified privileges from PUBLIC.