What happens if a Definer's Rights procedure [A} calls an Invoker's rights procedure [B]? Will B still execute as Invoker's Rights? (Doc ID 1500896.1)

Last updated on JANUARY 06, 2020

Applies to:

Goal

Answer the question(s):

What happens if a Definer's Rights procedure [A} calls an Invoker's rights procedure [B]?  Will B still execute as Invoker's Rights?

-and-

Why are DBMS_CQ_NOTIFICATION and DBMS_CHANGE_NOTIFICATION registering notifications for the current database user and not the definer if the package is called from a definer's rights procedure/package.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.