In the Interactive SQL Service Facility, you can use the SQL Data Control Language (DCL) to define the kind of access authorized for a particular resource. This includes granting privileges to other users or revoking those privileges. See How to Submit SQL Statements.
Gives specified privileges on tables and views in databases that are secured under the SQL Security Model. See GRANT for the statement syntax and more information.
Removes privileges on tables and views for which privileges have been given through the GRANT statement. See REVOKE for the statement syntax and more information.
Important! If the CA Datacom/DB Security Facility is not installed at your site, the GRANT and REVOKE statements are rejected with an SQL error code -559. 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.
|
Copyright © 2014 CA.
All rights reserved.
|
|