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

Home -> Community -> Mailing Lists -> Oracle-L -> Auditing ALTER DATABASE and ALTER SYSTEM commands

Auditing ALTER DATABASE and ALTER SYSTEM commands

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Fri, 17 Mar 2006 23:40:37 +0800
Message-Id: <6.2.1.2.0.20060317234014.01fb58b0@pop.singnet.com.sg>

Apparently, the "ALTER DATABASE" command
(eg ALTER DATABASE DATAFILE <filename> RESIZE) cannot be audited.

Although the "ALTER SYSTEM" can be audited, I cannot find from DBA_AUDIT_OBJECT or DBA_AUDIT_STATEMENT which ALTER SYSTEM command
(ALTER SYSTEM CHECKPOINT, ALTER SYSTEM SWITCH LOGFILE, ALTER SYSTEM SET
SORT_AREA_SIZE=)
was issued.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 17 2006 - 09:40:37 CST

Original text of this message

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