Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot create job chain

549039Jun 13 2010 — edited Feb 7 2012
Hi guys,
I've issued any role that I could think of...
grant manage scheduler to info;
grant create job to info;
grant create any rule to info;
grant execute on dbms_scheduler to info;
grant execute on dbms_isched to info;
grant create evaluation context to info;
but still insufficient privileges...
Error starting at line 44 in command:
BEGIN
    DBMS_SCHEDULER.CREATE_CHAIN (
         chain_name  => 'info.stepped_chain_demo'
        ,rule_set_name  => NULL
        ,evaluation_interval => NULL
        ,comments  => 'executes a job chain'
    );
END;
Error report:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 4856
ORA-06512: at "SYS.DBMS_ISCHED", line 1094
ORA-06512: at "SYS.DBMS_SCHEDULER", line 1598
ORA-06512: at line 2
01031. 00000 -  "insufficient privileges"
*Cause:    An attempt was made to change the current username or password
           without the appropriate privilege. This error also occurs if
           attempting to install a database without the necessary operating
           system privileges.
           When Trusted Oracle is configure in DBMS MAC, this error may occur
           if the user was granted the necessary privilege at a higher label
           than the current login.
*Action:   Ask the database administrator to perform the operation or grant
           the required privileges.
           For Trusted Oracle users getting this error although granted the
           the appropriate privilege at a higher label, ask the database
           administrator to regrant the privilege at the appropriate label.
Any ideea, what else....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2012
Added on Jun 13 2010
2 comments
4,249 views