Start of change

Creating a RACF group for database administrators and adding database administrators to the group

You need to create a RACF group for users who need database administration authority on the Spiffy database.

Procedure

  1. Define a RACF group for database administrators.
  2. Add IDs of database administrators to the group.

Example

To add user DBAOWNER, add RACF group DB2ADMIN with DBAOWNER as the owner, and add user ID ADMF010 to DB2ADMIN, use the following statements:
ADDUSER  DBAOWNER  CLAUTH(DSNR USER) UACC(NONE)          
ADDGROUP DB2ADMIN SUPGROUP(SYS1) OWNER(DBAOWNER)           
CONNECT DBAOWNER GROUP(DB2ADMIN) AUTHORITY(JOIN) UACC(NONE)
ALTUSER DBAOWNER DFLTGRP(DB2ADMIN)                         
CONNECT ADMF010 GROUP(DB2ADMIN)
End of change