Plan privileges
Resources: Application plans
Resource type: P
Db2 privileges
BIND
XAPLPRIV value: BINDAUTP
Privcode 65 (x'41')
Does the user or the role associated with the user own the plan?
If so, XAPLUPRM must match the owner name passed from Db2 by the XAPLOWNR parameter when XAPLONRT indicates an authorization ID, or XAPLUCHK must match XAPLOWNR and XAPLUCKT must match XAPLONRT.
If not, the user must have sufficient authority to:
| One of these resources: | In class: |
|---|---|
| Db2-subsystem.plan-name.BIND | MDSNPN or GDSNPN |
| Db2-subsystem.owner.BINDAGENT | MDSNSM or GDSNSM |
| Db2-subsystem.SYSDBADM | DSNADM |
| Db2-subsystem.SYSCTRL | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |
COMMENT ON
XAPLPRIV value: COMNTAUTP
Privcode 97 (x'61')
Does the user or the role associated with the user own the plan?
If so, XAPLUPRM must match the owner name passed from Db2 by the XAPLOWNR parameter when XAPLONRT indicates an authorization ID, or XAPLUCHK must match XAPLOWNR and XAPLUCKT must match XAPLONRT.
If not, the user must have sufficient authority to:
| One of these resources: | In class: |
|---|---|
| Db2-subsystem.owner.BINDAGENT | MDSNSM or GDSNSM |
| Db2-subsystem.SYSDBADM | DSNADM |
| Db2-subsystem.SYSCTRL | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |
EXECUTE
XAPLPRIV value: CHKEXECP
Privcode 64 (x'40')
The user must have sufficient authority to:
| One of these resources: | In class: |
|---|---|
| Db2-subsystem.plan-name.EXECUTE | MDSNPN or GDSNPN |
| Db2-subsystem.DATAACCESS | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |