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

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

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:

 

http://rampant-books.com/book_2003_2_audit.htm

 


Download your Oracle scripts now:

www.oracle-script.com

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 -2016 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