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™.
REVOKE statementUse the REVOKE statement to cancel access privileges or roles that are held by users, by roles, or by PUBLIC, or to cancel user security labels or exemptions from the rules of security policies.
Sequence-Level Privileges
Select Privilege

Select Privilege

You can revoke the Select privilege on a sequence from another user, from PUBLIC, or from a role. Select privilege enables a user or role to use the sequence.CURRVAL and sequence.NEXTVAL in SQL statements to access and to increment the value of a sequence.

The following REVOKE statement cancels any Select privilege that was granted individually to user mark on the cust_seq sequence object:

REVOKE SELECT ON cust_seq FROM mark;