Re: Auditing: Trigger or Audit_Trail?

Hi Teresa,

Thanks for your comments on my papers. I don't have 8.1.5 anymore to test with but i suspect that you have nailed the issue. If you have the final parameter static_policy missing then just leave it out. It should work the same. The parameter is to tell Oracle whether the predicate will always be the same (or not) each time the policy function is executed.

I am not sure what your issue is with the final slash, it's needed to execute the PL/SQL.

I hope this helps

Kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.