9. Ensuring Data Integrity : Database Events : How Database Events Work
 
Share this page                  
How Database Events Work
After a database event is defined for a table, it can be raised by all applications connected to the database, assuming appropriate privileges have been granted, as described in the Security Guide.
The event can be raised from interactive or embedded SQL applications, as a result of triggering a security alarm, or in a database procedure (where it can, in turn, be invoked by rules). It can also be received by all applications connected to the database and registered to receive the event.
In general, database events work as follows:
An application or the DBMS raises an event, that is, issues a notification that a defined event has occurred.
The DBMS notifies monitor applications that are registered to receive the event.
The receiving application responds to the event by performing the action the monitor application designer specified when writing the program.
Note:  You can also trace database events. For details, see the chapter “Using Monitoring and Tracing Tools” in the System Administrator Guide.