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:
Sequence-Level Privileges

1 ALL
2.1+ ,
2.1 ALTER
2.1 SELECT
2  ON
2?  'owner.' 
1 sequence
1 synonym
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.