DQ Internal Security › Securing Data Access for DQL Use › Specifying Table Options Using the USER Option › Copying Authorizations

Copying Authorizations

Summary

Copying authorizations from one user to another is a quick way to authorize new users to access the same tables and columns as an existing user. If a user has similar needs as an existing user, you can modify the authorizations after completing the copy function. You can copy tables only, codes only, or both tables and codes to the new user (target).

Copying Security

Copying security is copying database tables and profile codes from one user to another. To copy security, choose the SECURITY CONTROL option from the Administration Menu. Then select USER on the Security Maintenance Menu.

The new user and the existing user have to be listed on the Security User Directory panel. For more information about creating new user IDs, see Authorizing Users in CA Dataquery.

If external security is in effect, it overrides any changes you may make on user, database, or table authorizations.

Place the cursor on the name of the user to copy and press <PF5> COPY SECURITY. CA Dataquery displays the following panel:

Directory of User Copy Targets (DQLK0)

 =>
 Place the cursor on a name for the copy target and press the PF5/17 key.
 --------------------------------------------------------------------------DQLK0
 DATAQUERY:  DIRECTORY OF USER COPY TARGETS       START WITH => _______________
 -------------------------------------------------------------------------------
         Using user : ______________________________  for copy source
 -------------------------------------------------------------------------------
           USER NAME                 | DATE ADDED | DATE USED
 -------------------------------------------------------------------------------
                                     |            |
                                     |            |
                                     |            |
                                     |            |
                                     |            |
                                     |            |
                                     |            |
                                     |            |
                                     |            |
                                     |            |
                                     |            |
                                     |            |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2>  RETURN    <PF3>  COPY TABLES <PF4>  COPY CODES
 <PF5> COPY BOTH      <PF6>  NOT USED  <PF7>  BACKWARD    <PF8>  FORWARD

Place the cursor on the user name who is to receive the authorizations.

Copying Tables

To copy only table authorizations to the new user, place the cursor on the new user name and select <PF3> COPY TABLES.

Copying Codes

To copy only profile code authorizations to the new user, place the cursor on the new user name and press <PF4> COPY CODES.

Copying All Authorizations

To copy all of the authorizations from one user to another, place the cursor on the new user name and select <PF5> COPY BOTH. CA Dataquery displays a message indicating that the copy was successful.

Changing the Copied Security

To change any of the copied security, return to the Security User Directory panel, use the PF keys to show codes or tables, then press the PF key to update the codes or tables. For more information, see Specifying Table Options Using the USER Option.