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_userin the package specification
Authid clause immediatly follows the create procedure, create function, create package or create type statement.
