|
|
| |
 |
|
Oracle Tips by Burleson |
Chapter 11 Oracle Fine Grained Auditing
|
2 |
SELECT
SSN
FROM CLAIMS
SEE
CODE DEPOT FOR FULL SCRIPT
The value of claim amount is 600 for this
claim.
Audited. The audit condition is true (CLAIM_AMOUNT
> 500), the query contained the relevant columns SSN or
PROC_CODE. So it is audited. |
|
3 |
SELECT
PROC_CODE
FROM CLAIMS
SEE
CODE DEPOT FOR FULL SCRIPT
This returns a row where claim amount is
400
Not Audited. Although the selected columns
are in the relevant list, the audit condition is false (CLAIM_AMOUNT
is not greater than 500). So it is not audited. |
|
4 |
SELECT
CLAIM_AMOUNT
FROM CLAIMS
SEE
CODE DEPOT FOR FULL SCRIPT
This returns a row where claim amount is
400
Not Audited. Neither the audit condition is
evaluated to true (CLAIM_AMOUNT is not greater than 500) nor the
relevant columns are in the query. This is not audited. |
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:
|
|
|
