-
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:
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|