What are Invoker Rights and Definer Rights and how do you control the current user?
Invokers rights: By default, a Java class is associated with invokers rights; the class is not bound to its defining schema. The current user of any session executing the class is the same as the sessions login user. The privileges are checked at runtime, and external references are resolved in the schema of the current user. With invokers rights, you can centralize and share code across multiple schemas and applications while keeping data stored in each schema private and isolated. Definers rights: By assigning definers rights to a class, you bind the class to its defining schema. The effective user of any session executing the class is changed temporarily to the identity of the classs defining schema, and all unqualified references are looked for in the defining schema. Java classes loaded with definers rights can be executed without requiring the invoking session to be connected as the schema to which the code belongs. In SQL*Plus, you can define top-level call specifications intera
