CA Datacom SQL Security › SQL Security Model › Activating and Maintaining

Activating and Maintaining

Use CA Datacom/DB external security to define CATALOG authorizations to those users who are to be authorized to execute SQL CREATE TABLE statements in the default SQL database or another database which they do not own. For more information, see DBUTLTY and External Security.

Issue SQL Statements, from a program or online through the CA Dataquery SQL Mode or CA Datacom Datadictionary Interactive SQL Service Facility, to:

• Grant access rights for accessors of tables and plans.

  Note: For syntax of the plan security versions of the GRANT and REVOKE statements, see Plan Security.

• Define views and grant access rights to these views.

Note: For details about the syntax for all statements, see the CA Datacom/DB SQL User Guide.