title: Insufficient privilege DBMS_SCHEDULER job
body: <p>I have created a job in Oracle using following scheduler -</p>
  <pre><code>BEGIN
    DBMS_SCHEDULER.create_job (
      job_name        =&gt; 'MY_JOB',
      job_type        =&gt; 'PLSQL_BLOCK',
      job_action      =&gt; 'BEGIN my_pkg.pull_data(''Y''); END;',
      start_date      =&gt; '31-AUG-21 07.00.00 PM America/New_York',
      repeat_interval =&gt; 'freq=daily; byminute=0; bysecond=0;',
      enabled         =&gt; TRUE);
  END;
  /
  </code></pre>
  <p>When I am running job manually using below code -</p>
  <pre><code>BEGIN
    DBMS_SCHEDULER.RUN_JOB(
      JOB_NAME            =&gt; 'MY_JOB',
      USE_CURRENT_SESSION =&gt; FALSE);
  END;
  </code></pre>
  <p>The job is running as expected. However, scheduled same jobs are failed again and again with below error.</p>
  <pre><code>ORA-01031: insufficient privileges ORA-06512: at &quot;SCOTT.MY_PKG&quot;, line 246 ORA-06512: at line 1
  </code></pre>
  <p>Any suggestion, what I am doing wrong? I think I have sufficient privileges.
  Edit - If I call, individual procedure which is used in the job, it's working as expected. I have checked the line 246, which is a select statement from a table in the same schema as job, proc and other tables used by the proc.</p>
  <pre><code>BEGIN my_pkg.pull_data('Y'); END;
  </code></pre>