Figure 3: Group profile example

 
/* Create “group” user profiles */
CRTUSRPRF USRPRF(GPSALES) PASSWORD(*NONE) TYPE(*USER)
CRTUSRPRF USRPRF(GPPAY) PASSWORD(*NONE) TYPE(*USER)
/* Add user profiles to the groups */
CHGUSRPRF USRPRF(APPUSER1) GRPPRF(GPSALES)
CHGUSRPRF USRPRF(APPUSER2) GRPPRF(GPPAY)
…
CHGUSRPRF USRPRF(APPUSER3) GRPPRF(GPSALES) SUPGRPPRF(GPPAY)

/* Authorize group profiles to DB2 tables */
GRTOBJAUT OBJ(PAYTAB) OBJTYPE(*FILE) USER(GPPAY) AUT(*USE)
GRTOBJAUT OBJ(SALESTAB) OBJTYPE(*FILE) USER(GPSALES) AUT(*CHANGE)

 /* SQL version of granting table access to group profiles */ 
GRANT SELECT ON paytab TO gppay
GRANT SELECT,INSERT,UPDATE,DELETE salestab TO gpsales