||Oracle Tips by Burleson
Chapter 11 Oracle Fine Grained Auditing
the patient in that claim, etc. The requirement
might state to audit the query only if these columns are accessed.
The parameter in the function ADD_POLICY that does this is set as
=> 'SSN, PROC_CODE'
In this example, the audit records are
triggered only if the columns SSN and PROC_CODE are selected in the
query. These columns are referred to as Relevant Columns. By
default, all the columns of the object are relevant. Specifying this
parameter can limit the amount of audit generated.
Based on these two parameters, a complete
example of adding a policy is shown below.
'CLAIM_AMOUNT>500 OR PAID_AMOUNT>500',
The above text is
an excerpt from:
Oracle Privacy Security Auditing
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: