Java code in oracle DBMS_JOB and permissions
Hello,
We have some java code which is published as a package in oracle. We have this piece of code:
Statement createTempTable = getConnection().createStatement();
createTempTable.execute("create table store_list_dups as select * from store_list where rownum < 0");
createTempTable.close();
When we execute the published package, it is able to create this table. But the same package if its executed as a DBMS_JOB it throws this message.
oracle.jdbc.driver.OracleSQLException: ORA-01031: insufficient privileges.
Could someone shed some light over this issue: