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
ALL Keyword

ALL Keyword

You can use the ALL keyword to revoke both Alter and Select privileges from another user, from PUBLIC, or from a role.

The following example cancels any Alter and Select privileges that user mark holds on the cust_seq sequence object:

REVOKE ALL ON cust_seq FROM mark;

Whether mark can still access cust_seq after this statement executes depends on whether the user still holds Alter or Select privileges on cust_seq that were granted to PUBLIC, or if he holds a role to which unrevoked privileges on cust_seq have been granted.