Sample Code on Definer's rights versus Invoker's rights
(Doc ID 1406464.1)
Last updated on JANUARY 30, 2022
Applies to:PL/SQL - Version 184.108.40.206 and later
Information in this document applies to any platform.
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!
In this Document