Sample Code on Definer's rights versus Invoker's rights
(Doc ID 1406464.1)
Last updated on MARCH 11, 2015
Applies to:PL/SQL - Version 188.8.131.52 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Mar-2015***
How to accomplish the following specifications:
A procedure created by user A deletes rows from tables in User A schema. Next the procedure is executed as user B who has synonyms for tables with the same name as those in User A.
Expect the rows in User B schema to be deleted and not in schema A.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!