Grant database permissions

Perform the following to grant the appropriate permissions to the DIH schema.

DBMS scheduler

DIH must be able to create, update, and delete jobs, chains, and programs within the staging schema of the Oracle Database Scheduler. You need to ensure to grant the necessary permissions to the DIH tool.

To implement this, use the provided example statements, which should be executed as the SYSDBA user. When running the statements, remember to replace &1 with the name of the schema designated for the DIH database objects. In a conversion scenario, this is typically STGADM, although DIHADM or another chosen name may be used.

GRANT CREATE job TO &1;
GRANT execute ANY class TO &1;
GRANT manage scheduler TO &1;
begin DBMS_RULE_ADM.grant_system_privilege(
  privilege => DBMS_RULE_ADM.create_rule_set_obj, 
  grantee => '&1', grant_option => FALSE
);
DBMS_RULE_ADM.grant_system_privilege(
  privilege => DBMS_RULE_ADM.create_evaluation_context_obj, 
  grantee => '&1', grant_option => FALSE
);
DBMS_RULE_ADM.grant_system_privilege(
  privilege => DBMS_RULE_ADM.create_rule_obj, 
  grantee => '&1', grant_option => FALSE
);
END;

DBMS lock

DIH must have execute privileges on DBMS_LOCK, as this tool is used for optimistic locking to prevent concurrent updates.

Using the SYSDBA user, execute the following statement, where &1 is the DIH schema.

GRANT EXECUTE ON sys.dbms_lock TO &1;