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 8 General Oracle Auditing

stmt_audit_option_map 

– This data dictionary table lists all the options in auditing SQL statements. Table 8.2 has a listing of all options that are available.

system_privilege_map

 – So far we have talked about auditing on objects. Auditing can also be set on system privileges like ALTER SYSTEM. The system privilege statements that can be audited have been given in Table 8.2. This may seem similar to the table stmt_audit_option_map, but there is a very subtle but important difference. The table stmt_audit_option_map holds statements that can be audited, such as 'create procedure'. However, there is also a system privilege called 'create procedure'. When that is granted to a user, the audit action triggered is different and that is what is stored in the table system_privilege_map. These differences are explained elsewhere in this chapter.

Checking the Audit Trail

The raw audit trail is written in the table aud$, which may not be user-friendly. We briefly mentioned some of the views designed to facilitate the interpretation of the information contained in this table at the beginning of the chapter. Here we will discuss these in detail.

dba_audit_trail

This view reports all the records of the table aud$ after interpreting the columns, i.e. decoding the codes to proper descriptions, such as decoding the action codes to the names of those actions. Here are the columns of this view in detail.

COLUMN NAME

DESCRIPTION

OS_USERNAME

The operating system user who logged on.


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.