Privileges required for DBMS_SCHEDULER
533201Jan 19 2007 — edited Jan 22 2007Hi,
I want to know which are the privileges required for creating programs,chains,jobs,and schedules for a non dba user.
Our DBA has given us following grant ::
grant execute on dbms_scheduler to sarang;
Still i get error while creating jobs ::
SQL> ed
Wrote file afiedt.buf
1 begin
2 dbms_scheduler.create_job
3 (
4 job_name => 'DEMO_RUN_SH',
5 job_type => 'EXECUTABLE',
6 job_action => '/export/home/bwsolaris/test1.sh',
7 start_date => systimestamp,
8 job_class => 'DEFAULT_JOB_CLASS',
9 auto_drop => FALSE,
10 enabled => TRUE
11 );
12* end;
SQL> /
begin
*
ERROR at line 1:
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at line 2