Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fine-grained auditing question
Yes, the extra where clause is appended under all circumstances (barring any
bugs I might not be aware of). "Update EMP set sal=900 where ename='BOB'"
will indeed become "...where ename='BOB' and dept='SALES'"
Regards
HJR
"Trent" <trent_vinyl_at_hotmail.com> wrote in message
news:5d41cd33.0212161003.5bd1ff64_at_posting.google.com...
> I'm thinking about playing around with this and I have a few
> questions. All of the documentation I've read talks and shows how to
> use it for watching "selects",
>
> ie. DBMS_FGA.ADD_POLICY(
> object_schema => 'hr',
> object_name => 'emp',
> policy_name => 'chk_hr_emp',
> audit_condition => 'dept = ''SALES'' ',
> audit_column => 'salary');
>
> SELECT salary FROM hr.emp WHERE dept = 'SALES';
>
>
> If I do an update on this column, will the preceeding policy trigger
> an audit event? If not, can someone show me the code to do so?
>
> Lastly, is it possible to use fine-grained auditing to track only
> unsuccessful selects/updates/etc? If so, how?
>
> Thanks in advance.
Received on Mon Dec 16 2002 - 12:49:14 CST