This content has been marked as final. Show 1 reply
Welcome to the forum!
My Java class owner is SYS but I am calling it from another Login. Is it cause for issue.?
First you should not be creating objects as SYS. Although it is legal it is not at all recommended.
Your Java 'class' owner is SYS? Or the stored procedure owner is SYS? Which is it?
To call stored procedures using a different schema you have to grant EXECUTE permission on the stored procedure to the other user.
So if SYS owns the procedure MY_PROC and you want to allow user SCOTT to execute it grant SCOTT the EXECUTE privilege.
I am new to JavaStoredProcedures
GRANT EXECUTE ON MY_PROC TO SCOTT;
Then may I suggest you start reviewing the Java Developer's Guide
Chapter 5 covers 'Developing Java Stored Procedures' and the 'Security' section provides the answer to your question
In Oracle Database, all classes are loaded into a secure database and, therefore, are untrusted. A user requires the appropriate permissions to access classes and operating system resources. Likewise, all stored procedures are secured against other users. You can grant the EXECUTE database privilege to users who need to access the stored procedures.