DQ Internal Security › Securing Data Access for DQL Use › Naming a CA Datacom/DB Database and Table for User Access

Naming a CA Datacom/DB Database and Table for User Access

If external security is in effect, it overrides any changes you might make on user, database, or table authorizations. Verify that external and CA Dataquery authorizations match if you want to maintain user, database and table security with CA Dataquery and with the external package.

Action

To use CA Dataquery to specify a CA Datacom/DB database for a user to access:

Step 1

Choose the SECURITY CONTROL option from the Administrative Menu.

Step 2

Select DATABASE from the Security Maintenance Menu.

CA Dataquery displays the following panel:

Security Table Name (DQLB0)

 =>
Enter the appropriate information and press PF4.
------------------------------------------------------------------DQLB0
DATAQUERY:  SECURITY TABLE NAME
------------------------------------------------------------------------

 Enter the three-digit CA Datacom/DB Database Identifier to be used:
 Database ID :  ___

 Enter the three character CA Datacom/DB Table name:
 Table name: ___

 (Leave blank if you wish to process by
  CA Datacom/DB Database Identifier only)





 <PF1> HELP   <PF2> RETURN     <PF3> NOT USED     <PF4>  DISPLAY USERS

Action

Complete the panel and press <PF4> DISPLAY USERS.

Panel Description

DATABASE ID:

Enter a valid 1- to 3-digit database ID. This ID specifies the database that this user is to be authorized to access.

TABLE NAME:

Enter a valid 1- to 3-alphabetic database table name. This name is the name of the table that this user is authorized to access. Leave blank if you want to authorize the user for all tables in the specified database ID.

After you name a database and table on the Security Table Name panel, and press <PF4> DISPLAY USERS, CA Dataquery displays the Security User List panel.

Security User List (DQLC0)

 =>
 Place the cursor on a name to delete or update.  Use PF3 to add new users.
 --------------------------------------------------------------------------DQLC0
 DATAQUERY:  SECURITY USER LIST                         DBID: ___ TABLE: _____
 -------------------------------------------------------------------------------
           User name                 |  Find  | Update | Insert |  Erase
 -------------------------------------------------------------------------------
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
                                     |        |        |        |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2>  RETURN    <PF3>  ADD         <PF4>  UPDATE
 <PF5> NOT USED       <PF6>  DELETE    <PF7>  BACKWARD    <PF8>  FORWARD

PF Keys

The following list describes the unique PF keys on the Security User List panel.

Note: To use <PF4> UPDATE or <PF6> DELETE, you must select a user with the cursor position.

To see the entire list, press <PF8> FORWARD until you see the message, LAST PAGE, at the bottom of the screen.