Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DDL auditing - *Extremely* detailed
AUDIT ALL BY ACCESS;
SELECT * FROM DBA_STMT_AUDIT_OPTS;
CREATE TABLE T1 (C1 NUMBER);
SELECT * FROM DBA_AUDIT_TRAIL;
Season to taste. I prefer to NOAUDIT SESSION WHENEVER SUCCESSFUL =
afterwards.
For 9i, see also init.ora parameter AUDIT_SYS_OPERATIONS
:)
Rich
Rich Jesse System/Database Administrator rich.jesse_at_quadtechworld.com QuadTech, Sussex, WI USA
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> Sent: Tuesday, May 04, 2004 10:45 AM
> To: oracle-l_at_freelists.org
> Subject: Re: DDL auditing - *Extremely* detailed
>=20 >=20
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue May 04 2004 - 11:08:42 CDT
![]() |
![]() |