Required Permissions for Oracle Database Users

The Oracle Data Purge feature depends on advanced Oracle capabilities. For example, the dbms_job package is used as the scheduling mechanism for operations, and the dbms_alert package is used as the alerting mechanism for operations.

In addition to the standard permissions, database users must have the following permissions:

EXECUTE on SYS.DBMS_ALERT

SELECT on SYS.V_$PARAMETER

The permissions below are normally granted to PUBLIC, but make sure the permissions have been granted.

EXECUTE on SYS.DBMS_JOB

EXECUTE on SYS.UTL_SMTP

EXECUTE on SYS.DBMS_METADATA

EXECUTE on SYS.DBMS_OUTPUT

EXECUTE on SYS.DBMS_LOB

EXECUTE on SYS.PLITBLM

EXECUTE on SYS.DBMS_UTILITY

These SYSDBA privileges can be granted either by using the DCI to call the storage database component or manually. If using the DCI, append the Login Role of sysdba to the server_URL, like this:

jdbc:wm:oracle://DBserver:1521;servicename=orcl;sysLoginRole=sysdba