title: Oracle - Grant Create Job privilege to role
body: <p>Oracle - Grant Create Job privilege to role</p>
  
  <pre><code>Login user = JOEL
  
  User JOEL got error "ORA-27486: insufficient privileges ORA-06512: at 
  "SYS.DBMS_ISCHED", line 124 ORA-06512: at "SYS.DBMS_SCHEDULER", line 271 ORA- 
  06512: at line 1"
  </code></pre>
  
  <hr>
  
  <p>To resolve the above error, grant JOEL the following privilege:
      Grant Create Job to JOEL;
  Remarks: By granting Create Job to JOEL, this resolved the error above.</p>
  
  <hr>
  
  <pre><code>But, instead of granting "Create Job" directly to user JOEL, grant the 
  privilege by ROLE as follow:
  
  Create Role Job_Role;
  Grant Create Job to Job_Role;
  Grant Job_Role to JOEL;
  
  Remarks: User JOEL got the same error even granted with Job_Role
  </code></pre>
  
  <p>May i know why granting role is not working?
  Thank you.</p>