I do it with triggers for each table . I capture the old and new values and construct the sql , user, sysdate,table_name and rowid and insert them to a table . if you want i can send you one example . bunyamin ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 19, 2001 8:38 PM
> > > Does anyone have any recommendations on auditing data changes on several > tables? I want to keep before and after data along with username/timestamp. > > I'm thinking of a DML trigger on each table and each with its own audit > table? Or what about a single audit table (using TO_CHAR to convert all > non-character data into the BEFORE and AFTER columns; only CHAR, VARCHAR2, > DATE and NUMBER datatypes are used). That should be slightly more generic. > > Either way it seems a bit messy. Anybody got a better idea? (This audit > trail has to be readily visible to the users - ie. a table - Log Miner > isn't really practical). > > Many thanks for any suggestions. > - Bill. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bill Buchan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bunyamin karadeniz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
