DQ Internal Security › Limiting Access to Rows Using Conditions and Restrictions › Maintaining Conditions

Maintaining Conditions

A condition is appended with an AND to any query or dialog in which the user accesses a table for which data access is restricted. For example,

FIND ALL SALES WITH YTD-SALES GT 1000
 AND id=15 AND CITY=DALLAS

This condition limits the users access to data based on the content of the data in two columns. id=15 allows the user to access only those rows in the table in which the value of the ID is equal to 15. Any other rows where the ID is not equal to 15 are not accessible. Furthermore, this condition limits access to those rows in which ID=15 and CITY=DALLAS. If a row met the first condition criteria, id=15, but did not meet the second condition criteria, CITY=DALLAS, the user would be unable to access any data in that row. The only data the user can access is in the rows that meet the criteria specified in the condition.

Access Conditions

To create, view, or edit a condition, begin by selecting the CONDITIONS option from the Administrative Menu, or use the CONDITION command from the command line. CA Dataquery displays the Directory of Conditions. A sample Directory of Conditions panel follows:

Directory of Conditions (DQKW0)

=>
Place the cursor on a name to delete or edit and press the appropriate PFkey
--------------------------------------------------------------------------DQKW0
DATAQUERY: DIRECTORY OF CONDITIONS                START WITH: _______________
-------------------------------------------------------------------------------
     CONDITION NAME                |  TABLE NAME
-------------------------------------------------------------------------------
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
-------------------------------------------------------------------------------
<PF1>  HELP       <PF2>  RETURN       <PF3>  CREATE       <PF4>  EDIT
<PF5>  NOT USED   <PF6>  DELETE       <PF7>  BACKWARD     <PF8>  FORWARD

Action

The START WITH: field, located in the upper-right corner of this panel, is where you enter the full or partial condition where you want the listing to start. When you press Enter, CA Dataquery displays the condition 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 following list describes each column of the Directory of Conditions panel.

CONDITION NAME

Alphabetical listing of all existing conditions.

TABLE NAME

Name of the table to which this condition applies.

PF Keys

The following PF keys are unique to the Directory of Conditions panel. The remainder of this section explains each function.

Note: <PF4> EDIT and <PF6> DELETE require selection of a condition using the cursor position.