Re: Auditing ALTER DATABASE and ALTER SYSTEM commands

From: <jo_holvoet_at_amis.com>
Date: 17-Mar-2006 16:52:41 CET
Message-Id: <200603171552.k2HFqcx27729@amis-colo-mail1.vanco.nl>

You could use a DDL trigger to capture this.

mvg/regards

                                                                           
             Hemant K Chitale                                              
             <hkchital_at_singnet                                             
             .com.sg>                                                   To 
             Sent by:                  ORACLE-L_at_freelists.org              
             oracle-l-bounce_at_f                                          cc 
             reelists.org                                                  
                                                                   Subject 
                                       Auditing ALTER DATABASE and ALTER   
             17-03-06 16:40            SYSTEM commands                     
                                                                           
                                                                           
             Please respond to                                             
             hkchital_at_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




--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 17 2006 - 09:52:41 CST