Previous Topic: Specifying Table Options Using the USER OptionNext Topic: Changing Authorizations

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 about 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 be modified 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:

Key

Objective

Result

CLEAR

Return to Security User
List panel Menu

CA Dataquery displays the Security User List panel

<PF1> HELP

Display Help panels

CA Dataquery displays the Help panel

<PF2> RETURN

Return to previous panel

Returns to previous panel, or Main Menu

<PF3> ADD

Add new database ID and
table for this user

CA Dataquery displays Security Table Maintenance panel

<PF4> UPDATE

Update a function
authorization for this user

CA Dataquery displays Security Table Maintenance panel

<PF5> NOT USED

Not in use

<PF6> DELETE

Delete a database ID and
table for this user

CA Dataquery displays message indicating results

<PF7> BACKWARD

Scroll to previous page

Displays previous page

<PF8> FORWARD

Scroll to next page of list,
if any

Displays the next page of list, if any

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