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.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.