Security for ASF tables

CA OLQ secures ASF tables regardless of the status of CA OLQ security. To ensure table security, we recommend the following:

IDs use the same passwords across all dictionaries
The IDMSNWKQ and IDMSNWKS subschemas use the same page ranges

Passkeys:

CA OLQ has automatic security for ASF tables. When a user tries to access a table, CA OLQ uses catalog security to make sure the user has proper authority assigned through passkeys.

The table functions and the passkeys required by the Automatic System Facility (ASF) are presented in Table 10. Passkeys affect ASF tables and reports.

Table 10. How Passkeys affect CA OLQ Table Processing

To Perform	User Default Passkey Required	Data Access Passkey Required
Select	COPY	COPY
Create	CREATE	N/A
Append	ADD	ADD
Replace	ADD	ADD
Delete	ERASE	ERASE
Show tables	BROWSE	N/A
Show directory	BROWSE	N/A

A user default passkey is a passkey given to a user that allows the user to perform a specific function on any ASF table.

A data access passkey is a passkey associated with a specific table. It allows a specific user to perform a function on a specific table.

In addition to supporting passkey security, OLQ supports row-level security.

Note: For more information about row-level security, see the CA IDMS Performance Monitor System Administration Guide.