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!

run job under restricted mode

Swee Chin Koo41 hours ago — edited 37 hours ago

dbms_scheduler.create_job (job_name => 'DBMS_JOB$_'||ln_job_no
,job_type => 'PLSQL_BLOCK'
,job_action => 'begin bpg_post_batch.bpc_gen_post_batch('
||p_batch_no
||','||ln_job_no
||','||''''||p_user||''''
||','||''''||p_prog||''''
||','||'to_date('||''''||to_char(p_date,'dd/mm/rrrr')||''''||','||''''||'dd/mm/rrrr'||''''||')'
||','||'to_date('||''''||to_char(p_batch_date,'dd/mm/rrrr')||''''||','||''''||'dd/mm/rrrr'||''''||')'
||'); end;'
,start_date => systimestamp
,auto_drop => true
,enabled => true
);

 DBMS\_SCHEDULER.SET\_ATTRIBUTE ( name      => 'DBMS\_JOB$\_'||ln\_job\_no  
                                ,attribute => 'ALLOW\_RUNS\_IN\_RESTRICTED\_MODE'  
                                ,value     => TRUE  
                              );

 DBMS\_SCHEDULER.ENABLE('DBMS\_JOB$\_'||ln\_job\_no);

 DBMS\_SCHEDULER.run\_job('DBMS\_JOB$\_'||ln\_job\_no);  

I try to run job under restricted mode where my userid has below system privileges but job is not running. It only run after i disable to restricted mode.

GRANT ANALYZE ANY TO ABCDIS;
GRANT CREATE SESSION TO ABCDIS;
GRANT QUERY REWRITE TO ABCDIS;
GRANT RESTRICTED SESSION TO ABCDIS;

Can advise how to run the job where DB is under restricted mode? thank you

Comments
Post Details
Added 41 hours ago
1 comment
60 views