The following table describes the privileges required in order to execute each function of pdrorg:
pdrorg function | Table subject to processing | ||
---|---|---|---|
Data dictionary table | User-defined table | Audit trail table | |
Table reorganization | DBA privilege | SELECT, INSERT, and DELETE privileges or DBA privilege | SELECT, INSERT, and DELETE privileges |
Table unloading | DBA privilege | SELECT or DBA privilege | SELECT privilege |
Table reloading | N | INSERT, DELETE, or DBA privilege | INSERT and DELETE privileges |
Reorganization, unloading, and reloading in units of schemas | N | DBA privilege or schema's owner | Audit privilege |
Batch index creation | N | No privilege required | No privilege required |
Index re-creation | N | No privilege required | No privilege required |
Index reorganization | N | No privilege required | No privilege required |
N: Cannot be executed.