Rights for Job creation in Oracle 11
Hello,
I need to create job on production database to update statistics for one table. I found good explanation under: https://www.opencodez.com/oracle/oracle-job-scheduler-guide-examples-part-1.htm
Author mentioned that following rights are needed for the user to create job:
GRANT CREATE ANY JOB TO <USER NAME>;
GRANT EXECUTE ON DBMS_SCHEDULER TO <USER NAME>;
GRANT MANAGE SCHEDULER TO <USER NAME>;
END;
BEGIN
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_RULE_OBJ, '<USER NAME>');
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, '<USER NAME>');
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ,