Table space privileges
Resources: Table spaces
Resource type: R
Note: Having a database privilege on database DSNDB04 is
the equivalent of having the privilege on any implicit database.
Db2 privileges
DROP, ALTER
XAPLPRIV values: DROPAUTR, ALTERAUTR
Privcode 73 (x'49'), 61 (x'3D')
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:
| One of these resources: | In class: |
|---|---|
| Db2-subsystem.database-name.DBADM | DSNADM |
| Db2-subsystem.SYSDBADM | DSNADM |
| Db2-subsystem.SYSCTRL | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |
Note: If the database was created implicitly, database-name must
be DSNDB04, not the name of the implicit database.
USE
XAPLPRIV value: USEAUTR
Privcode 87 (x'57')
The user must have sufficient authority to:
| One of these resources: | In class: |
|---|---|
| Db2-subsystem.database-name.tablespace-name.USE | MDSNTS or GDSNTS |
| Db2-subsystem.database-name.DBADM | DSNADM |
| Db2-subsystem.SYSDBADM | DSNADM |
| Db2-subsystem.SYSCTRL | DSNADM |
| Db2-subsystem.SYSADM | DSNADM |