REVOKE

This SQL statement can be executed in the following ways:	Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)	In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)	By using CA Dataquery (SQL & Batch Modes)
REVOKE	YES	YES	YES

Note: YES indicates a valid execution method for this statement. To learn about using SQL keywords in CA Dataquery, see the CA Dataquery User Guide. For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

Important! If CA Datacom/DB security is not installed at your site, the REVOKE statement is rejected with an SQL error code -559.

CA Datacom/DB provides the REVOKE statement as an extension so you can revoke privileges on tables and views for which privileges have been granted through the GRANT statement. All tables and views in the statement must belong to databases secured under the SQL Security Model. If tables and views are in databases secured under the CA Datacom/DB External Security Model, the GRANT and REVOKE statements are rejected with an SQL error code -273. See the CA Datacom Security Reference Guide for more information about security models.