User-defined distinct type privileges
Resources: User-defined distinct types
Resource type: E
Db2 privileges
USAGE
XAPLPRIV value: USAGEAUTE
Privcode 263 (x'107')
Does the user or the role associated with the user own the user-defined distinct type?
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.schema-name.type-name.USAGE | MDSNUT or GDSNUT |
| Db2-subsystem.SYSDBADM | DSNADM |
| Db2-subsystem.DATAACCESS | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |