Previous Topic: CA Datacom Datadictionary SecurityNext Topic: SQL Security


CA Dataquery Security

CA Dataquery security protects product functions unique to the product. These functions include CA Dataquery online and batch activity. CA Dataquery internal security uses a secondary product signon for each accessor and permits you to define Table Authorizations in CA Dataquery security. External security uses the external security user identification and validates table access according to the authorizations defined in CA Datacom/DB security.

The Security Administrator controls whether CA Dataquery is secured with external security. If external security is selected for CA Dataquery, then CA Dataquery internal security authorizations are ignored. No modifications are required to CA Dataquery to implement external security. Security settings for databases with DBIDs greater than 999 is only supported in external security.

Using the CA Datacom/DB SECURITY Multi-User startup option and your external security product, CA Dataquery security is recognized as a separate path in CA Datacom/DB with the LEVEL05 PASS/FAIL resource. If the proper permissions are set for the level 05 resource, you can specify four paths specifically for CA Dataquery.

Note: CA Dataquery internal security can be used even though CA Datacom/DB is using external security.