Authorizing Users › Accessing User Information › Limiting User Functions to Manipulate Data

Limiting User Functions to Manipulate Data

CA Dataquery allows you to limit a user's ability to FIND, UPDATE, INSERT, and ERASE data based on their ability to access that data. Once you have identified all tables, rows, and columns and their related restrictions, you should decide which functions you will permit the user to perform on the accessible data. Users should always be permitted to FIND the data in the authorized tables. However, you most likely want to limit some users' ability to UPDATE, INSERT, and/or ERASE data. The administrator with SECURITY CONTROL authorization assigns the FIND, UPDATE, INSERT, or ERASE functions when he authorizes each user to a table or profile code in DQL Mode.