3 Replies Latest reply: Apr 9, 2013 5:07 AM by user4461879 RSS

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


      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,