Audit of System control files

[Mokash]

Dear friends,

Master Tabel Audit Detailed Report is not showing the records when system control file is changed. What is other option to audit the system control file.

Thank you .......................

 

[Kishor Chari]

Control files changes are NOT maintained or reported.what we have done is program trigger for each table (control) export the old/new value to a text file.

/* Developed By : Kishor Chari Date : 26th Sept 2004 ECO# */
/* Database Trigger for control files in MFG/PRO to create file output */
/* If modified. Both old & New Values are sent to the output file */

TRIGGER PROCEDURE FOR WRITE OF adc_ctrl OLD buffer old_adcctrl.


DEF VAR FILE_name AS c.

{mfdeclre.i}

FIND FIRST CODE_mstr NO-LOCK WHERE CODE_fldname = "control_file"
AND CODE_value = "File" NO-ERROR.

FILE_name = CODE_cmmt + "\" + "adctrl" + STRING ( YEAR (TODAY) ,"9999")
+ STRING (DAY (TODAY), "99")
+ STRING (MONTH (TODAY) , "99")
+ SUBSTRING ( STRING (TIME, "HH:MM"),1,2 )
+ SUBSTRING ( STRING (TIME, "HH:MM"),4 ) +
".txt".


OUTPUT TO VALUE (FILE_name) APPEND PAGED PAGE-SIZE 60.

{mfphead.i}

PUT "**** OLD VALUE ****" SKIP
"*******************" SKIP
"User: " + GLOBAL_userid FORMAT 'x(30)'
"Date: " + STRING (TODAY) FORMAT 'x(15)'
"Time: " + STRING (TIME ,"HH:MM:SS" ) FORMAT 'x(15)'.


DISP OLD_adcctrl WITH STREAM-IO DOWN FRAME x1 2 COL
SIDE-LABELS WIDTH 100.

PUT SKIP (2)
"**** NEW VALUE ****" SKIP
"*******************" SKIP
"User: " + GLOBAL_userid FORMAT 'x(30)'
"Date: " + STRING (TODAY) FORMAT 'x(15)'
"Time: " + STRING (TIME ,"HH:MM:SS" ) FORMAT 'x(15)'.


DISP adc_ctrl WITH STREAM-IO DOWN FRAME x2 2 COL
SIDE-LABELS WIDTH 100.

DISP
"************ End of Report ************"
WITH STREAM-IO DOWN FRAME x3 WIDTH 50 CENTERED.