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

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:


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.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.