Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  Oracle Tips by Burleson

Chapter 3 Introducti

on to Oracle Auditing

types of triggers with scripts, which can be re-used in a real production environment.

Another way to capture the changes made to the database is from a tool called Log Miner. Any change in the Oracle database is written to a special type of file called a redo log. When a redo log file is filled up, it is stored as another type of file called an archived log file. These files are necessary when the database suffers a failure and the DBA needs to restore the data files up to the point of failure during a recovery.

Log Miner can go through these log files and capture the changes that occurred, along with the user ID, the timestamp, and a host of other information. This tool is more accurate in Oracle 9i than in Oracle 8i, nevertheless, it can offer valuable clues to data changes.

Log Miner auditing is explained in detail, along with scripts, in Chapter 9.

Use triggers to audit changes to sensitive data. These changes can also be recoded via Log Miner.

DDL Auditing

Oracle has two types of SQL statements. The statements that access data in any way, such as SELECT, INSERT, DELETE, and UPDATE etc. belong to a part of the SQL language known as Data Manipulation Language (DML). Developers and users accessing the data primarily use this. The other type of statements that define the database and its objects are known as Data Definition Language (DDL). The DDLs are used to create tables, views, procedures, etc. They are also used
 

The above text is an excerpt from:

Oracle Privacy Security Auditing

The Final Word on Oracle Security

 

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 immediate download of working security scripts:

 

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



 
 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.