Hi,
One of the developers is getting an error ORA-27486:insufficient privileges
ORA-06512:at SYS.DBMS_ISCHED
when trying to run this job.
dbms_scheduler.create_job(
job_name => 'run_rulemgr',
job_type => 'PLSQL_BLOCK',
job_action => 'begin ath_load_rulemgr_pkg.run_rulemgr; end; ',
start_date => null,
repeat_interval =>null,
enabled => TRUE,
comments => 'Rule manager'
);
I would not want to give DBA privilege to the user.
Please let me know what privileges need to be given ?
Regards,
Narayan