Database privileges

Db2 administrative authority

DBCTRL

XAPLPRIV value: DBCTLAUTD

Privcode 68 (x'44')

The user must have sufficient authority to:

Db2 privileges

Check Data Utility

XAPLPRIV value: CHKDAUTD

Privcode 295 (x'127')

The user must have sufficient authority to:

CREATETAB

XAPLPRIV value: CRTTBAUTD

Privcode 94 (x'5E')

The user must have sufficient authority to:

CHANGE NAME QUALIFIER

XAPLPRIV value: QUALAUTD

Privcode 76 (x'4C')

The user must have sufficient authority to:

CREATETS

XAPLPRIV value: CRTTSAUTD

Privcode 95 (x'5F')

The user must have sufficient authority to:

DISPLAYDB

XAPLPRIV value: DSPDBAUTD

Privcode 99 (x'63')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

DROP

XAPLPRIV value: DROPAUTD

Privcode 73 (x'49')

The user must have sufficient authority to:

MERGECOPY

XAPLPRIV value: MERGEAUTD

Privcode 237 (x'ED')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

IMAGCOPY, MODIFY RECOVERY, QUIESCE

XAPLPRIV values: IMCOPAUTD, MODAUTD, QUIESAUTD

Privcode 74 (x'4A'), 238 (x'EE'), 239 (x'EF')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

RECOVERDB, REPORT

XAPLPRIV values: RECDBAUTD, REPRTAUTD

Privcode 89 (x'59'), 240 (x'F0')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

REORG

XAPLPRIV value: REORGAUTD

Privcode 77 (x'4D')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

REPAIR

XAPLPRIV values: REPARAUTD

Privcode 78 (x'4E')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

RUN REPAIR UTILITY

XAPLPRIV values: DIAGAUTD

Privcode 236 (x'EC')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

REPAIR DBD

XAPLPRIV value: RDBDAUTD

Privcode 241 (x'F1')

The user must have sufficient authority to:

RUN CHECK INDEX/LOB UTILITY

XAPLPRIV values: CHECKAUTD

Privcode 19 (x'13')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

STATS

XAPLPRIV values: STATSAUTD

Privcode 82 (x'52')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

STARTDB

XAPLPRIV value: STARTAUTD

Privcode 79 (x'4F')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

STOPDB

XAPLPRIV value: STOPAUTD

Privcode 83 (x'53')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to:

TERM UTILITY

XAPLPRIV value: TERMAUTD

Privcode 109 (x'6D')

The user must have sufficient authority to:

TERM UTILITY ON DATABASE

XAPLPRIV value: TERMDAUTD

Privcode 58 (x'3A')

If the database was created implicitly, and the user or the role associated with the user owns the other object (XAPLUPRM is equal to XAPLOON when XAPLOOOT indicates an authorization ID, or XAPLUCHK is equal to XAPLOON and XAPLUCKT is equal to XAPLOOT), access is allowed.

If not, the user must have sufficient authority to: