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

Limiting Access to Rows Using Conditions and Restrictions

CA Dataquery provides you with the ability to restrict users' access to data using profile codes, restrictions, and conditions. These security measures are maintained by CA Dataquery and are not overridden by external security.

As the CA Dataquery Administrator, you can restrict access to data in a named database according to the value of the data itself. The vehicle which names the values that cannot be retrieved is called a restriction.

You assign a restriction to an individual user or a user group. A restriction consists of one or more conditions that prevent retrieval of specific data. A typical condition is ZIP CODE NOT EQUAL 75044. When a query (or dialog) executes against the restricted database, CA Dataquery inserts the conditions in the query and thus qualifies the data that is retrieved. With this method, you apply additional qualifications to a user's queries, allowing the user to view only those rows which satisfy both the query and the user's assigned restricted condition(s).

To restrict a user, follow these steps:

Step 1

Define the condition, giving it a name.

Step 2

List its name on the panel that defines a named restriction.

Step 3

Decide which user or group of users to restrict with the condition. Use the RESTRICTIONS option on the Administrative Menu to assign the condition to an individual user.