Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: audit access
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
![]() |
![]() |