Previous Topic: Authorizing Data Access Using the Security Maintenance MenuNext Topic: Specifying Table Options Using the USER Option


How to Limit Access to Tables

Sign on to CA Dataquery and select the SECURITY CONTROL option from the Administrative Menu or enter the SECURITY command on the command line. CA Dataquery then displays the Security Maintenance Menu.

Security Maintenance Menu (DQLA0)

 =>  --------------------------------------------------------------------DQLA0  DATAQUERY: SECURITY MAINTENANCE MENU  -------------------------------------------------------------------------  ENTER DESIRED OPTION NUMBER  ___  1.   DATABASE       - Authorize by CA Datacom/DB Bases and Tables to Users  2.   USER           - Authorize by User to CA Datacom/DB Bases and Tables  ----------------------------------------------------------------------  <PF1> HELP     <PF2>  RETURN

The CA Dataquery SECURITY CONTROL function provides you with the following options to assign a user to a CA Datacom/DB table:

Panel Description

DATABASE

This option allows you to name the CA Datacom/DB ID and tables that you are allowing a user to access.

For details about using this option, see Naming a CA Datacom/DB Database and Table for User Access.

USER

This option allows you to select the user to assign and then select the CA Datacom/DB ID and tables to which this user is allowed to perform the FIND, UPDATE, INSERT, or ERASE commands. You can also copy security from one user to another. These options allow you to specify whether the user can FIND, UPDATE, INSERT, or ERASE the data on that table. We suggest that you authorize users to the FIND function for the tables they require. Without this authorization, the user cannot read the data in the table.

For details about using this option, see Specifying Table Options Using the USER Option.