Previous Topic: How to Limit Access to TablesNext Topic: Modifying Table Authorizations Related to One User


Specifying Table Options Using the USER Option

Access

To authorize a user to perform FIND, UPDATE, INSERT, or ERASE on specific tables, choose the SECURITY CONTROL option from the Administrative Menu. Then select USER from the Security Maintenance Menu. To go directly to the Security User Directory panel, enter SECURITY USER on the command line. (If you must relate many users to many tables, an alternative to online entry exists. See Using CA Datacom Datadictionary to Relate Multiple Users to Tables for details.) CA Dataquery displays the Security User Directory panel.

Security User Directory (DQLM0)

=>  Place the cursor on a name and press the appropriate PF key.  --------------------------------------------------------------------------DQLM0  DATAQUERY:  SECURITY USER DIRECTORY              START WITH => _______________  -------------------------------------------------------------------------------            USER NAME                 | DATE ADDED | DATE USED  -------------------------------------------------------------------------------                                      |            |                                      |            |                                      |            |                                      |            |                                      |            |                                      |            |                                      |            |                                      |            |                                      |            |                                      |            |                                      |            |                                      |            |                                      |            |  -------------------------------------------------------------------------------  <PF1> HELP          <PF2>  RETURN   <PF3>  SHOW TABLES   <PF4>  SHOW CODES  <PF5> COPY SECURITY <PF6>  DELETE   <PF7>  BACKWARD      <PF8>  FORWARD  <PF9> NOT USED      <PF10> NOT USED <PF11> DELETE TABLES <PF12> DELETE CODES

Action

The START WITH field, located in the upper-right corner of this panel, is where you enter the full or partial name of the user where you want the listing to start. When you press ENTER, CA Dataquery refreshes the SECURITY USER DIRECTORY panel with the user that you specified on the first line of the listing. You can also page forward using <PF8> FORWARD or backward using <PF7> BACKWARD until you reach the member that you want to view and/or edit.

Panel Description

The panel provides you with a list of users who are defined in the CA Dataquery system. It does not, however tell you which users are authorized to access CA Dataquery with the external security package. The panel enables you to perform many tasks specified by the PF keys. The following list explains each column on the panel.

USER NAME

Names each user currently authorized on CA Dataquery.

DATE ADDED

Lists the date the user was added to CA Dataquery.

DATE USED

Lists the date that the user last accessed CA Dataquery.

PF Keys

The following list describes the unique PF keys for the panel-name panel.

Key

Objective

Result

<PF3>
SHOW TABLES

Display tables authorized for user selected with cursor

CA Dataquery displays the Security Table List panel

<PF4>
SHOW CODES

Display profile codes authorized for user selected with cursor. See How to Limit Access to Columns

CA Dataquery displays Security Profile Code List panel

<PF5>
COPY SECURITY

Copy user authorization from user selected with cursor to another user

CA Dataquery displays Directory of User Copy Targets panel

<PF6> DELETE

Delete both table and profile code authorizations for user selected with cursor

CA Dataquery displays message indicating results

<PF11> DELETE TABLES

Delete table authorizations for user selected with cursor

CA Dataquery displays message indicating results

<PF12> DELETE CODES

Delete profile code authorizations for cursor

CA Dataquery displays message user selected with indicating results