Sequence-Level Privileges
Although HCL
OneDB™ implements
sequence objects as tables, only the following subset of the table
privileges (as described in Table-Level Privileges)
can be granted or revoked on a sequence:
- Select privilege
- Alter privilege
Use the following syntax to specify privileges to revoke
on a sequence object:
Element | Description | Restrictions | Syntax |
---|---|---|---|
owner | Owner of the sequence or of its synonym | Must be the owner | Owner name |
sequence | Sequence on which to revoke privileges | Must exist | Identifier |
synonym | Synonym for a sequence object | Must point to a sequence | Identifier |
The sequence must reside in the current database. (You can qualify the sequence or synonym identifier with a valid owner name, but the name of a remote database (or database@server) is not valid as a qualifier.) Syntax to revoke sequence-level privileges is an extension to the ANSI/ISO standard for SQL.