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: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Thu, 30 Oct 2003 15:13:17 +0000
Message-ID: <Mc9zffANqSo$QxMO@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 - 09:13:17 CST

Original text of this message

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