DQ Internal Security › Securing Data Access for DQL Use › Specifying Table Options Using the USER Option › Adding Authorizations

Adding Authorizations

To add a new database ID for the selected user, press <PF3> ADD. CA Dataquery displays the Security Table Maintenance panel.

Security Table Maintenance (DQLH0)

 =>
 Enter the security information and press the appropriate PF key.
 --------------------------------------------------------------------------DQLH0
 DATAQUERY:  SECURITY TABLE MAINTENANCE  USER: ________________________________
 -------------------------------------------------------------------------------
          Data Base ID           :
           DB Table Name         :          (Enter *ALL* for all tables of the
                                             database ID)

                             Find:
                           Update:
                           Insert:
                            Erase:









 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2>  RETURN    <PF3>  NOT USED    <PF4>  UPDATE D

If external security is in effect, it overrides any changes you might make on user, database, or table authorizations.

Panel Description

The panel provides the means to add authorizations to the user ID you specified on the Security Table List panel. The following list explains each column on the panel:

DATABASE ID

List the 1-3 digit database ID.

DB TABLE NAME

Names the table to be related to the user.

FIND, UPDATE, INSERT, ERASE

Represent the CA Dataquery functions which the users can be authorized to perform. A Y following a table name and database ID in one of these columns indicates the user can perform that particular function.

To add a table to this list of accessible tables for this user, enter the 3-digit database ID and the table name, or enter *ALL* to give the user access to all tables in this database. Press <PF3> ADD to process.