Database Administration (MOSC)

MOSC Banner

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center