Figure 5: Authorization list example

/* Create authorization list */
CRTAUTL AUTL(HSALESAL) AUT(*EXCLUDE)
/* Associate tables with authorization list */
GRTOBJAUT OBJ(HSALESTB1) OBJTYPE(*FILE) AUTL(HSALESAL)
…
GRTOBJAUT OBJ(HSALESTBN) OBJTYPE(*FILE) AUTL(HSALESAL)

/* Give users access to the authorization list */
ADDAUTLE AUTL(HSALESAL) USER(BIZUSER1) AUT(*USE)
ADDAUTLE AUTL(HSALESAL) USER(BIZUSER2) AUT(*USE)

/* Administrator needs update capabilities for tables on authorization list */
ADDAUTLE AUTL(HSALESAL) USER(DWADMIN) AUT(*CHANGE)