Securing Data Access for DQL Use › Naming a CA Datacom/DB Database and Table for User Access › Using the Datadictionary to Relate Multiple Users to Tables

Using the Datadictionary to Relate Multiple Users to Tables

When you need to add many table/user authorizations, you can use CA Datacom Datadictionary as an alternative to using the online CA Dataquery facility. Follow these steps:

Step 1

Build a entity-occurrence for the AUTHORIZATION entity-type for the performance of a function on a particular table. The format is:

$DQ-tttt-fffiii

$DQ

Constant

tttt

Identifier for the type of access or update:

• DISR for FIND (retrieval)
• UPDR for UPDATE
• ADDR for INSERT
• DELR for ERASE

fff

CA Datacom/DB table name

iii

DATABASE ID

For example, the entity-occurrence for a table named CMP in database 001 for FIND is:

$DQ-DISR-CMP001

Define your entity-occurrences to CA Datacom Datadictionary and put them in production status. See the CA Datacom Datadictionary Online Reference Guide for more information.

Step 2

Add the user in online CA Dataquery. This creates a entity-occurrence within the PERSON entity-type in PROD status. For more information, see Adding a User to a Table

Step 3

Relate the PERSON in Step 2 to the appropriate AUTHORIZATIONS in Step 1. See the CA Datacom Datadictionary Online Reference Guide for instructions.