In 9iR2, I am attempting to create a policy with DBMS_FGA that includes
a complex join in the audit_condition. Of all the examples I have seen,
they include only simple where clauses, such as dept = 10, sal > 3000,
etc. Is it possible to have a complex join in the audit_condition? In
other words, the interested rows that Oracle identifies for the audited
table are based on a join to another table. I have been able to create
the policy with such a condition and enable it with no errors, but am
unable to trigger it. I suspect that it may be due to the aliases used
for the columns in the where clause.
Any input would be appreciated.
Received on Tue Mar 07 2006 - 17:37:45 CST
