How to Copy Authorities (all) from one Auth ID to another Auth ID using RC/Secure

Products

• RC/Secure for DB2 for z/OS

Issue/Introduction

In RC/Secure for Db2 for z/OS (RCS) how can authorities be copied from one authid to another authid.

Resolution

In RC/Secure:

•  Go to Option 2: GRS  Standard Grant/Revoke Services.  
•  Specify 'C' (copy) for the Option
•  On the subsequent screen (below) enter the FROM and TO Authid.
  
  

RSCOPY  20.0   -------- RC/S GRS Copy Authorizations -------  2020/01/07 16:07

 Command ==>

                                                                                                    SYSID: ssid

                                                                                                    SQLID: USER01

  COPY FROM AUTHID => USER01    > SSID => ssid  LOCATION => LOCAL            >

  GRANT TO  AUTHID =>   USER02    > SSID => ssid  LOCATION => LOCAL             >

         Object Type:  *

         Object Name: *                   > Object Qualifier: *         >

 

          Detail of authorizations  => Y   ( Y: Yes, N: No ) 

 

• An '*' in the Object Name or Qualifier will copy ALL authorizations for all objects of the type chosen for the 'FROM' authid.
• To wildcard those fields use a '%', example EMP%.
• Detail of Authorizations: Indicate whether you would like to review the list of authorities to be granted before GRS issues the GRANTS and REVOKES.