Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
GRANT statementUse the GRANT statement to assign access privileges and roles to users and to other roles. Users who hold the DBSECADM role can use this statement to assign user security labels and exemptions from label-based access control (LBAC) security rules.
Sequence-Level Privileges

Sequence-Level Privileges

Although HCL OneDB™ implements sequence objects as tables, only a subset of table-level privileges (page Table-Level Privileges) can be granted on a sequence. You can grant the Select or Alter privilege (or both) on a sequence:

Notes:

¹ HCL OneDB extension


Element	Description	Restrictions	Syntax
owner	Owner of sequence (or owner of synonym)	Must be the owner	Owner name
sequence	Sequence on which to grant privileges	Must exist	Identifier
synonym	Synonym for a sequence object	Must exist	Identifier

The sequence object must exist 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. You can include the WITH GRANT OPTION keywords when you grant ALTER, SELECT, or ALL to a user or to PUBLIC (but not to a role) as privileges on a sequence object.