Database Administration (MOSC)

MOSC Banner

Rights for Job creation in Oracle 11

edited Nov 25, 2019 3:10PM in Database Administration (MOSC) 2 commentsAnswered ✓

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:

BEGIN

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,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center