Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy



Oracle Tips by Burleson

Chapter 9 Oracle System Event Trigger Auditing

  • DDL triggers -- Using the DDL trigger, the Oracle DBA can automatically track all changes to the database including changes to tables, indexes, and constraints. The data from this trigger is especially useful for change control and auditing changes to the production environment.  This is especially important for Oracle databases that are “certified” by government agencies.

While Oracle provided the functionality for these new triggers, it was not clear how they could be used in order to track system-wide usage. This chapter describes our work in creating end-user log in/log off procedures to facilitate tracing end-user activity.  Please be advised that the initial implementation of system level triggers for end-user tracking is quite new, and as such is still a bit lacking in robust functionality.

While the user log on/log off triggers will accurately tell you the time of the user log on and user log off, the code does not capture any information regarding the specific tasks that were performed during the user's session. Also note that these user log on and log off triggers are best used for those types of applications that utilize time stamped users.  By time stamped users, we mean those users who are given a unique Oracle user ID when they access the application.  Applications that do not utilize the time stamped Oracle user IDs (SAP, PeopleSoft) may not benefit greatly by using these log on and log off triggers.

Now let's take a closer look at how these triggers work with Oracle tables.

Database Startup Event Triggers

Package pinning has become a very important part of Oracle tuning. With the introduction of system-level

The above text is an excerpt from the bestselling book: Oracle Privacy Security Auditing It's only $39.95 and has an download of working security scripts:


This is the only authoritative book on Oracle Security, Oracle Privacy, and Oracle Auditing written by two of the world’s leading Oracle Security experts.

This indispensable book is only $39.95 and has an download of working security scripts:


Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks