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

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


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Chapter 11 Oracle Fine Grained Auditing

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


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


 and has an immediate download of working security scripts:


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.