Skip to Main Content

Oracle Database Discussions

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!

Privileges required for DBMS_SCHEDULER

533201Jan 19 2007 — edited Jan 22 2007
Hi,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2007
Added on Jan 19 2007
4 comments
46,790 views