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 11 Oracle Fine Grained Auditing

DB_USER OBJECT_NAME POLICY_NAME TO_CHAR(TIMESTAMP,'
------- ----------- ----------- -------------------
SQL_TEXT
---------------------------------------------------
JUDY    VW_CLAIMS   VW_CLAIM     08/17/2003 23:24:13
select * from claim_schema.vw_claims

Note the use of the view name in the OBJECT_NAME column, instead of the base table name. In addition, there is no other record for the selection from the base table.

If a policy is defined on a base table, the FGA record will be generated even if the table is selected indirectly, such as where a view based on that table is queried. If the policy is specifically defined on the view, then the audit record is generated if the view is queried, not the table. When a table is queried by Oracle indirectly, such as in enforcing a Foreign Key constraint, the FGA auditing is not enabled.

Prerequisite

The FGA can work only in Cost Based Optimizer. This means the optimizer_mode and optimizer_goal in both session and system (where appropriate) levels should not be set to RULE. Also, the tables should be properly analyzed, with at least estimated statistics. Additionally, the statement should not have the RULE hint in it.

The FGA will appear to work under the Rule Based Optimizer (RBO), but the results will be inaccurate with a large number of false positives. Do not use FGA under RBO.


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.