Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: audit access
thx a lot
"Pete Finnigan" <plsql_at_petefinnigan.com> skrev i melding
news:Mc9zffANqSo$QxMO_at_peterfinnigan.demon.co.uk...
> Hi ES
>
> if you want to audit changes to the table structure then for instance if
> you wish to audit any alter table commands by the user vpd do:
>
> SQL> audit alter table by vpd;
>
> Audit succeeded.
>
> SQL>
>
> to turn it off do:
>
> SQL> noaudit alter table by vpd;
>
> Noaudit succeeded.
>
> SQL>
>
> to audit selects on for instance the dictionary view all_users do:
>
> SQL> audit select on all_users by access;
>
> Audit succeeded.
>
> SQL>
>
> again to turn it off do:
>
> SQL> noaudit select on all_users;
>
> Noaudit succeeded.
>
> SQL>
>
> The by access is not needed,
> 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.
Received on Thu Oct 30 2003 - 16:25:49 CST