Optimize 10.7 | webMethods Optimize Documentation | Administering webMethods Optimize | For Database Administrators | Purging Data from Optimize Database Components | Using Data Purge | Required Permissions for Oracle Database Users
 
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