www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Administration
Data Access Interfaces
Virtual Database Engine
SQL Reference
Virtuoso Cluster Programming
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 Data Access and Data Management
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

OpenLink Software
OpenLink Software
2015
Database Startup
license About isPartOf
12.1. Database Startup
OpenLink Software
OpenLink Software
2015
Database Connections
license About isPartOf
12.2. Database Connections
OpenLink Software
OpenLink Software
2015
Database Logins
license About isPartOf
12.3. Database Logins
OpenLink Software
OpenLink Software
2015
Database Disconnections
license About isPartOf
12.4. Database Disconnections
OpenLink Software
OpenLink Software
2015
Database Shutdown
license About isPartOf
12.5. Database Shutdown
OpenLink Software
OpenLink Software
2015
SQL Statement Preparation
license About isPartOf
12.6. SQL Statement Preparation
OpenLink Software
OpenLink Software
2015
SQL Parse Tree
license About isPartOf
12.7. SQL Parse Tree
12.7.1. Notes on Special Features of the Parse Tree
12.7.2. SQL Security and Parse Trees
12.7.3. Debugging with Parse Trees
OpenLink Software
OpenLink Software
2015
WebDAV Logins
license About isPartOf
12.8. WebDAV Logins
OpenLink Software
OpenLink Software
2015
Associating Auxiliary Data With A Connection
license About isPartOf
12.9. Associating Auxiliary Data With A Connection

OpenLink Software
OpenLink Software
2015
Database Event Hooks
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.
license About isPartOf About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About About

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:

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.