8.1.12 Executor

The following table describes the privileges required in order to execute each function of pdrorg:

pdrorg functionTable subject to processing
Data dictionary tableUser-defined tableAudit trail table
Table reorganizationDBA privilegeSELECT, INSERT, and DELETE privileges or DBA privilegeSELECT, INSERT, and DELETE privileges
Table unloadingDBA privilegeSELECT or DBA privilegeSELECT privilege
Table reloadingNINSERT, DELETE, or DBA privilegeINSERT and DELETE privileges
Reorganization, unloading, and reloading in units of schemasNDBA privilege or schema's ownerAudit privilege
Batch index creationNNo privilege requiredNo privilege required
Index re-creationNNo privilege requiredNo privilege required
Index reorganizationNNo privilege requiredNo privilege required

N: Cannot be executed.

Note
When the Directory Server linkage facility is used, the executor must have as its role the indicated privilege as a pdrorg executor.