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.
Table-Level Privileges
Effect of the ALL Keyword

Effect of the ALL Keyword

The ALL keyword revokes all table-level privileges. If any or all of the table-level privileges do not exist for the revokee, REVOKE with the ALL keyword executes successfully but returns the following SQLSTATE code:

01006--Privilege not revoked

For example, assume that user hal has the Select and Insert privileges on the customer table. User jocelyn wants to revoke all table-level privileges from user hal. So user jocelyn issues the following REVOKE statement:

REVOKE ALL ON customer FROM hal;

This statement executes successfully but returns SQLSTATE code 01006. The SQLSTATE warning is returned because both of the following are true:

The statement succeeds in revoking the Select and Insert privileges from user hal because user hal had those privileges.
SQLSTATE code 01006 is returned because user hal lacked other privileges implied by the ALL keyword, but these privileges were not revoked.

The ALL keyword instructs the database server to revoke everything possible, including nothing. If the user from whom privileges are revoked has no privileges on the table, the REVOKE ALL statement still succeeds, because it revokes everything possible from the user (in this case, no privileges at all).