DQ Internal Security › Accessing User Information › Limiting User Functions to Manipulate Data

Limiting User Functions to Manipulate Data

CA Dataquery allows you to limit the ability of a user 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, decide which functions you permit the user to perform on the accessible data. Users should always be permitted to FIND the data in the authorized tables. However, you probably want to limit the ability of some users to UPDATE, INSERT, and 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.