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

Changing Authorizations

To change function authorizations, select a DBID and table name with the cursor and press <PF4> UPDATE. CA Dataquery displays the following panel:

Security Table Maintenance (DQLH0)

 =>
 Enter the security information and press the appropriate PF key.
 --------------------------------------------------------------------------DQLH0
 DATAQUERY:  SECURITY TABLE MAINTENANCE  USER: ________________________________
 -------------------------------------------------------------------------------
          Data Base ID           :
           DB Table Name         :          (Enter *ALL* for all tables of the
                                             database ID)

                             Find:
                           Update:
                           Insert:
                            Erase:









 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2>  RETURN    <PF3>  NOT USED    <PF4>  UPDATE D

Note: Removing all the authorizations for a particular user deletes that user from the list the next time the user attempts to access that table and does not allow access to that table. If external security is in effect, it overrides any changes you might make on database or table authorizations.

Enter Y or N next to the functions.

If a user had access to only selected tables in a database, to authorize that user access to the entire database, enter *ALL* as the Table Name. The *ALL* authorization supersedes, but does not delete, the individual table authorizations.

For example, if a user had only FIND access to some tables and you want to give that user full access to the entire database, enter *ALL* as the Table Name and, on the next panel, add the user with FIND, UPDATE, INSERT, and ERASE authority. With the *ALL* authorization the user now has FIND, UPDATE, INSERT, and ERASE access to all tables in the database.

If the user previously had FIND and UPDATE access to a specific table and (with the *ALL* authorization) you specify FIND access to all tables in the database, the user is able to FIND any table but able to UPDATE only the specific table.

When checking authorization, CA Dataquery looks for individual specific table authorization and if that is not found, CA Dataquery looks for *ALL* authorization.