Previous Topic: Creating or Modifying a RestrictionNext Topic: Sample Condition and Restriction

DQ Internal Security › Limiting Access to Rows Using Conditions and Restrictions › Creating or Modifying a Restriction › Deleting a Restriction

Deleting a Restriction

When you need to remove a restriction from a user or group, begin by selecting the RESTRICTIONS option from the Administrative Menu, or using the RESTRICTIONS command from the command line. CA Dataquery displays the Directory of Restrictions panel, as shown in the following example:

Directory of Restrictions (DQKX0)

=>
Place cursor on a name and press the appropriate PFkey
--------------------------------------------------------------------------DQKX0
DATAQUERY: DIRECTORY OF RESTRICTIONS   START WITH: ____________________________
-------------------------------------------------------------------------------
    USER NAME OR GROUP ID          |  TABLE NAME
-------------------------------------------------------------------------------
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
                                   |
-------------------------------------------------------------------------------
<PF1>  HELP       <PF2>  RETURN       <PF3>  CREATE       <PF4>  EDIT
<PF5>  NOT USED   <PF6>  DELETE       <PF7>  BACKWARD     <PF8>  FORWARD

Action

Scroll through this panel until you locate the user or group name and its associated table name. Position the cursor beside the user or group and press <PF6> DELETE. CA Dataquery immediately deletes that restriction and refreshes the panel. The restriction is no longer in effect when the user or a user assigned to the group accesses the previously restricted table.

For an explanation of the fields and PF keys for the Directory of Restrictions panel, see Using Conditions to Restrict Data.