To create or modify an existing restriction, choose the RESTRICTIONS option from the Administrative Menu, or use the RESTRICT command from the command line. When the Directory of Restrictions panel appears, position the cursor next to a restriction and press <PF3> EDIT to modify an existing restriction. CA Dataquery then displays the Restriction Edit panel, as shown in the following example, allowing you to modify the existing restriction relative to a user or group.
Restriction Edit (DQKA0)
=> OVERTYPE THE CONDITIONS TO BE MODIFIED AND PRESS <PF4> TO COMPLETE THE UPDATE --------------------------------------------------------------------------DQKA0 DATAQUERY: RESTRICTION EDIT ------------------------------------------------------------------------------- USER ________________________________ GROUP ID: LV1 _______________ LV2 _______________ LV3 _______________ TABLE: ________________________________ ------------------------------------------------------------------------------- CONDITIONS: _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ _______________ ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DISPLAY CONDITION <PF4> SAVE <PF5> LIST CONDS <PF6> DELETE <PF7> NOT USED <PF8> NOT USED
Panel Description
A list of the fields and descriptions from the Restriction Edit panels follows.
Enter the user name to whom this restriction applies. If you do not enter a user name, you must specify a Group ID.
Specify one of the following against which this restriction is to apply.
If you do not enter a group ID, you must enter a user name.
Enter the CA Datacom Datadictionary TABLE entity-name that names the table to which you want to limit access. CA Dataquery requires that the condition applies to the same table as the associated restriction.
Enter one or more condition names which are to restrict the user's and group's access to the named table. The conditions named are connected by AND and processed at query execution time.
Displaying a Condition
To review a condition that you have listed on the Restriction Edit panel, press <PF3> DISPLAY CONDITION. (The cursor must be positioned by the condition name.) CA Dataquery displays that condition on the Editor panel. Press <PF2> RETURN when you have finished viewing the condition to return to the Restriction Edit panel.
Saving Your Restriction
When you are creating or editing a restriction on the Restriction Edit panel, you must save your work. Simply press <PF4> SAVE before leaving this panel. CA Dataquery saves your new restriction, lists it on the Directory of Restrictions panel, and puts it into effect for the designated user(s) and/or group(s) when they execute a query that accesses the table to which this restriction applies. (If you have applied a condition to a user who is outside of your group, the assignment will not be listed on your panel, even though it exists.)
Viewing a Listing of Existing Conditions
When you are viewing the Restriction Edit panel, you might want to refresh your memory as to what the names of the existing conditions are and their associated table names. When you press <PF5> LIST CONDS, CA Dataquery displays the Directory of Conditions panel for that purpose. For more information about the Directory of Conditions panel, see Maintaining Conditions.
Deleting a Condition Within a Restriction
When you want to remove one or more conditions imposed on a user and/or a group, begin by selecting the RESTRICTIONS option from the Administrative Menu, or use the RESTRICT command from the command line. When CA Dataquery displays the Directory of Restrictions panel, position the cursor beside the user name or group ID that you want to modify. Then press <PF4> EDIT to display the Restriction Edit panel.
Position the cursor on the condition name that you want to delete and blank it out, or use Erase End of Field and press <PF4> SAVE to save. CA Dataquery immediately deletes that condition and refreshes the panel. The change in the restriction is not applicable to any user or group ID listed in the restriction until the next time that a query is executed that accesses that restricted table.
CA Dataquery requires that a restriction must contain at least one condition.
|
Copyright © 2014 CA.
All rights reserved.
|
|