Loadjava - privileges while executing
Hello,
I want to execute some java code in the database and put the code in the schema TESTSCHEMA, the java library files in a JAVASCHEMA. When executing my code I have some user execution problems.
My version of db is: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
As I also want logging I am starting with implementing logback , therefor I used loadjava to import the jar files in a utility schema JAVASCHEMA with the option to create the public synonyms and the grants for both schemas.
dbms_java.loadjava('-r -v -f -jarsasdbobjects -genmissing -force -synonym -grant JAVASCHEMA,TESTSCHEMA -cleargrants -schema JAVASCHEMA logback-classic-1.3.11.jar');