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;