Sequence privileges
Resources: Sequences
Resource type: Q
Db2 privileges
ALTER
XAPLPRIV value: ALTERAUTQ
Privcode 61 (x'3D')
Does the user match the schema name?
If so, XAPLUPRM or XAPLUCHK must match the schema name passed from Db2 by the XAPLOWNQ parameter.
If not, does the user or the role associated with the user own the sequence?
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.object-name.ALTERIN | MDSNSC or GDSNSC |
| Db2-subsystem.schema-name.sequence-name.ALTER | MDSNSQ or GDSNSQ |
| Db2-subsystem.SYSDBADM | DSNADM |
| Db2-subsystem.SYSCTRL | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |
COMMENT ON
XAPLPRIV value: COMNTAUTQ
Privcode 97 (x'61')
Does the user match the schema name?
If so, XAPLUPRM or XAPLUCHK must match the schema name passed from Db2 by the XAPLOWNQ parameter.
If not, does the user or the role associated with the user own the sequence?
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.object-name.ALTERIN | MDSNSC or GDSNSC |
| Db2-subsystem.schema-name.sequence-name.ALTER | MDSNSQ or GDSNSQ |
| Db2-subsystem.SYSDBADM | DSNADM |
| Db2-subsystem.SYSCTRL | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |
USAGE
XAPLPRIV value: USAGEAUTQ
Privcode 263 (x'107')
Does the user or the role associated with the user own the sequence?
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 XAPLACAC is enabled (XAPLFLG2 bit 5 is '1'B ) and XAPLUCHK is an authid, 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.sequence-name.USAGE | MDSNSQ or GDSNSQ |
| Db2-subsystem.DATACCESS | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |