When defining a database in CA Datacom Datadictionary, you may designate it as secured under the SQL Security Model rules. Choosing this option for a database means that the security for resources in this database is maintained using SQL GRANT and REVOKE statements.
If you choose this option, you are choosing not to secure user access for this database in external security. However, we recommend that all security be implemented in external security. A pair of resources is checked in external security either when you catalog or open the database with the SQL security option. This allows the Security Administrator to have control over the use of the SQL security model. The check consists of a pair of resources in the DTSYSTEM resource class as follows:
If access is granted to the ALLOW resource and access is denied to the DENY resource, the open or catalog continues. If not, the open or catalog fails with a CA Datacom/DB return code 15(001).
|
Copyright © 2014 CA.
All rights reserved.
|
|