OWNER vs JOB_CREATOR in DBMS_SCHEDULER

OWNER vs JOB_CREATOR in DBMS_SCHEDULER

A few days ago I received an email from a subscriber. The question looked simple… but it came with a twist: Good morning Javier, I have two database users: 1. OWNER 2. DBA DBA creates a job where the owner is user OWNER. The job runs without issues. The user DBA is...
Insufficient privileges and PL/SQL

Insufficient privileges and PL/SQL

If you have been working with Oracle for some time, you have most likely seen this scenario: From SQL, an operation works. From an anonymous PL/SQL block, it also works. From a stored procedure… ORA-01031: insufficient privileges. The usual way to try to fix it...