Owner Names with Database Events
Owner names associated with database event commands are always assumed to be SYSTEM. If an owner name other than system is passed to the Oracle gateway for a database event operation, an event owner of SYSTEM is used and an informational message is logged to errlog.log. If no owner name is provided, the Oracle gateway assumes an owner name of SYSTEM.
Example:
create dbevent user_a.event_a;
register dbevent user_a.event_a;
If user_b created and registered for user_b.event_a as follows:
register dbevent user_b.event_a;
Then user_a raised user_a.event_a as follows:
raise dbevent user_a.event_a;
Then user_b would receive notification that event_a was raised.
Last modified date: 02/16/2024