Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: audit access

Re: audit access

From: E S <fuel_at_dritt.info>
Date: Thu, 30 Oct 2003 23:25:49 +0100
Message-ID: <3cgob.35303$os2.513228@news2.e.nsc.no>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US