Mandatory Privilege required for Database Users

Oracle Database for Order User

The order database user must have the following privileges:

  • ALTER SESSION SET CONTAINER = orcl;

  • grant resource, connect, create session to OM_ORDER_USER;

  • grant alter session to OM_ORDER_USER;

  • grant execute on dbms_redefinition to OM_ORDER_USER;

  • grant create any sequence to OM_ORDER_USER;

  • grant create any table to OM_ORDER_USER;

  • grant alter any table to OM_ORDER_USER;

  • grant drop any table to OM_ORDER_USER;

  • grant lock any table to OM_ORDER_USER;

  • grant select any table to OM_ORDER_USER;

  • grant create any index to OM_ORDER_USER;

  • grant create any trigger to OM_ORDER_USER;

  • grant create any job to OM_ORDER_USER;

Oracle Database for the Archival Service User

The Archival database user must have the following privileges:

  • ALTER SESSION SET CONTAINER = orcl;

  • grant resource, connect, create session to OM_ARCHIVAL_USER;

  • grant alter session to OM_ARCHIVAL_USER;

  • grant execute on dbms_redefinition to OM_ARCHIVAL_USER;

  • grant create any sequence to OM_ARCHIVAL_USER;

  • grant create any table to OM_ARCHIVAL_USER;

  • grant alter any table to OM_ARCHIVAL_USER;

  • grant drop any table to OM_ARCHIVAL_USER;

  • grant lock any table to OM_ARCHIVAL_USER;

  • grant select any table to OM_ARCHIVAL_USER;

  • grant create any index to OM_ARCHIVAL_USER;

  • grant create any trigger to OM_ARCHIVAL_USER;

  • grant create any job to OM_ARCHIVAL_USER;