Los wrote:
> 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.
I can't think of any reason why a complex join wouldn't be possible
but I no longer have 9i on any of my servers.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Mar 07 2006 - 18:04:06 CST
