This discussion is archived
3 Replies Latest reply: Apr 8, 2013 10:07 PM by user4461879 RSS

Granting execute right to a java class already loaded in one schema

587477 Newbie
Currently Being Moderated
Hi,

I have one class (info.teggy.Logger) already loaded in schema teggy and I want to execute that class from schema scott. How do I grant the execute right to schema scott ?

Is there a way similar to what is usually done for pl/sql packages (i.e. running the following command when connected as teggy "grant execute on PKGLogger to scott") ?

From what I have read so far, it would seem this can be done using Loadjava utility. Unless that cannot be prevented, I don't want to reload the java class in the database and from what I understand, running "loadjava -grant scott Logger.jar" will reload and update the java code in the database.

Thanks for the reply,
Teggy

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points