DQ Internal Security › Securing Data Access for DQL Use › Specifying Table Options Using the USER Option › Modifying Table Authorizations Related to One User

Modifying Table Authorizations Related to One User

See Specifying Table Options Using the USER Option for instructions on selecting a user name on the Security User Directory panel and pressing <PF3> SHOW TABLES to see the Security Table List panel.

Security Table List (DQLG0)

  =>
 Place the cursor on a file name to delete or update.  Use PF 3 to add tables.
 --------------------------------------------------------------------------DQLG0
 DATAQUERY:  SECURITY TABLE LIST         USER: ________________________________
 -------------------------------------------------------------------------------
     Database ID   |   DB Table Name |  Find    Update   Insert    Erase
 -------------------------------------------------------------------------------
                   |                 |
                   |                 |
                   |                 |
                   |                 |
                   |                 |
                   |                 |
                   |                 |
                   |                 |
                   |                 |
                   |                 |
                   |                 |
                   |                 |
                   |                 |
                   |                 |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2>  RETURN    <PF3>  ADD         <PF4>  UPDATE
 <PF5> NOT USED       <PF6>  DELETE    <PF7>  BACKWARD    <PF8>  FORWARD

Panel Description

The panel lists tables currently related to the user ID you specified on the Security User Directory panel with their function authorizations. The following list explains each column on the panel.

Database ID

Lists each table name's database ID.

DB Table Name

Names each table currently secured to the user.

FIND, UPDATE, INSERT, ERASE

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

The fields on this screen are for display only. No data can be entered.

Action

To make any necessary changes or additions on the Security Table List panel, place the cursor on the line with the DB Table Name and Database ID to modify and press the appropriate PF key. <PF3> ADD, <PF4> UPDATE, and <PF6> DELETE are discussed in detail on the following pages.

PF Keys

The following list describes the PF keys:

Note: To use <PF4> ADD or <PF6> DELETE, select a table/DBID using cursor position.