Sample Code on Definer's rights versus Invoker's rights
Last updated on MARCH 11, 2015
Applies to:PL/SQL - Version 126.96.36.199 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms