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....