martedì 25 agosto 2009

Execute a procedure under another schema

Problem:
There are two users, A and B.
User A creates a procedure.
User B wants to run that procedure, but he wants to affect the tables of his own schema, not the tables of user A!

Solution:
You can simply add
authid current_user
in the package specification

Authid clause immediatly follows the create procedure, create function, create package or create type statement.

Nessun commento:

Posta un commento