Global variable privileges
Resources: Global variables
Resource type: H
Db2 privileges
READ
XAPLPRIV value: READAUTH
Privcode 291(x'123')
Does the user or the role associated with the user own the variable?
If so, XAPLUPRM must match the owner name that is passed from Db2 by the XAPLOWNR parameter when XAPLONRT indicates that an authorization ID XAPLUCHK must match XAPLOWNR, and an authorization ID XAPLUCKT must match XAPLONRT.
If XAPLACAC is on (XAPLFLG2 bit 5 is '1'B ) and XAPLUCHK is an authorization ID, suppress the ownership check for XAPLUCHK.
If not, the user must have sufficient authority to:
| One of these resources: | In class: |
|---|---|
| Db2-subsystem.schema-name.variable-name.READ | MDSNGV or GDSNGV |
| Db2-subsystem.DATAACCESS | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |
WRITE
XAPLPRIV value: WRITEAUTH
Privcode 292 (x'124')
Does the user or the role associated with the user own the variable?
If so, XAPLUPRM must match the owner name that is passed from Db2 by the XAPLOWNR parameter when XAPLONRT indicates that an authorization ID XAPLUCHK must match XAPLOWNR and an authorization ID XAPLUCKT must match XAPLONRT.
If XAPLACAC is on (XAPLFLG2 bit 5 is '1'B ) and XAPLUCHK is an an authorization ID, suppress the ownership check for XAPLUCHK.
If not, the user must have sufficient authority to:
| One of these resources: | In class: |
|---|---|
| Db2-subsystem.schema-name.variable-name.WRITE | MDSNGV or GDSNGV |
| Db2-subsystem.DATAACCESS | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |