Privileges for DBA user

Required Privileges for DBA User

The DBA user is a user ID with the DBA role granted. The DBA_USER (usually SYSTEM) creating the IEE schema requires the following roles and object privileges:

Roles:

GRANT CONNECT TO <DBA_USER>;

GRANT DBA TO <DBA_USER>;

ALTER USER <DBA_USER> DEFAULT ROLE ALL;

Object Privileges:

GRANT SELECT ON SYS.DBA_DIRECTORIES TO <DBA_USER> WITH GRANT OPTION;

GRANT SELECT ON SYS.DBA_SCHEDULER_JOBS TO <DBA_USER> WITH GRANT OPTION;

GRANT SELECT ON SYS.DBA_SCHEDULER_JOB_CLASSES TO <DBA_USER> WITH GRANT OPTION;

GRANT SELECT ON SYS.DBA_SCHEDULER_PROGRAMS TO <DBA_USER> WITH GRANT OPTION;

GRANT EXECUTE ON SYS.DBMS_LOCK TO <DBA_USER> WITH GRANT OPTION;

GRANT EXECUTE ON SYS.DBMS_SHARED_POOL TO <DBA_USER> WITH GRANT OPTION;

GRANT EXECUTE ON SYS.DBMS_SCHEDULER to <DBA_USER> WITH GRANT OPTION;