Re: Auditing ALTER DATABASE and ALTER SYSTEM commands

You could use a DDL trigger to capture this.

mvg/regards

Jo




                                                                           
             Hemant K Chitale                                              
             <hkchital@singnet                                             
             .com.sg>                                                   To 
             Sent by:                  ORACLE-L@xxxxxxxxxxxxx              
             oracle-l-bounce@f                                          cc 
             reelists.org                                                  
                                                                   Subject 
                                       Auditing ALTER DATABASE and ALTER   
             17-03-06 16:40            SYSTEM commands                     
                                                                           
                                                                           
             Please respond to                                             
             hkchital@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

Other related posts: