Previous Topic: Performing User Table Maintenance  (DQUSERMT)Next Topic: Condition/Restriction Reporting (DQCRRPT) Statements


Limit Access to Columns with the Security Control Function

SHOW CODES

Allows you to assign Datadictionary profile codes which protect sensitive column data to users who need to access the protected data. A profile-code is an attribute of a column that is used by CA Dataquery to classify columns into various security groups. Once a profile-code is established and included in the column definition, only users who are authorized for that code can access data in the protected columns. If Y (yes) has been specified on the DATA AUTHORIZED field on the User Table Maintenance panel, a user without profile-code authorization can read the data.

COPY SECURITY

Allows you to copy to another user one or all of the authorizations that have been assigned to one user. The security access can remain the same or be further modified for the new user.

COPY CODES

Allows you to copy the profile codes assigned to one user to another user. Another method of restricting access to data is the use of conditions and restrictions. Conditions are created which qualify access to rows of data based on data values.