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.

Note

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