# 10. Database Event Hooks

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Server Administration
Data Access Interfaces
SQL Reference
SQL Procedure Language Guide
Database Event Hooks
Database Startup
Database Connections
Database Logins
Database Disconnections
Database Shutdown
SQL Statement Preparation
SQL Parse Tree
WebDAV Logins
Associating Auxiliary Data With A Connection
Data Replication, Synchronization and Transformation Services
Web Application Development
XML Support
RDF Database and SPARQL
Web Services
Runtime Hosting
Internet Services
Free Text Search
TPC C Benchmark Kit
Using Virtuoso with Tuxedo
Appendix
Virtuoso Functions Guide

## 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.

## Table of Contents

10.1. Database Startup
10.2. Database Connections
10.3. Database Logins
10.4. Database Disconnections
10.5. Database Shutdown
10.6. SQL Statement Preparation
10.7. SQL Parse Tree
10.7.1. Notes on Special Features of the Parse Tree
10.7.2. SQL Security and Parse Trees
10.7.3. Debugging with Parse Trees
10.8. WebDAV Logins
10.9. Associating Auxiliary Data With A Connection

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.

Previous Row Level Security | Chapter Contents | Next Database Startup