Chapter12.Database Event Hooks

Abstract

Virtuoso provides a number of hooks that enable you to traps events within the database such as startup, shutdown, connection, disconnection and SQL compilation events.

Virtuoso allows the dba to set hooks for various events, such as:

Startup
Shutdown
Client Connect
Client Disconnect
Compilation of a Dynamic SQL Statement

These events are intercepted by calling a SQL procedure if one is defined.

In the following we will examine each hook in the context of a simplified database security system. The system will record all logins and logouts and will enforce custom security rules on reading a specific application table.