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

amounts more than $500. If the user selects any claim below that amount, it is not worth keeping an auditing record.

FGA can easily handle this. The parameter audit_condition that was not used in the earlier example can be used to trigger auditing selectively. To satisfy the requirement, we could specify the parameter


in the dbms_fga.add_policy procedure. By default, all access queries are audited, regardless of the data returned. The above parameter will restrict the auditing information. Even if the query does not specify the clause, if any of the rows returned contain a claim amount of more than 500, the auditing is triggered.

The parameter can also be provided in multiple conditions, e.g.

audit_condition=>'CLAIM_AMOUNT>500 OR PAID_AMOUNT>500'

Here the auditing will be triggered if either of the conditions CLAIM_AMOUNT>500 or PAID_AMOUNT>500 is satisfied in the retrieved data.

Relevant Columns

Once again, HIPAA requirements could determine the change in strategy. Typically, the law might ask that access only to certain columns be audited, for example to sensitive columns containing Personal Health Information. In your case, the columns are perhaps Social Security Number (SSN), procedures conducted 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


 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.