Find table from audit record

Posted in 2015

Topics: Security, Permissions & Auditing

Habichtsberg, Reinhard — Fri, 30 Oct 2015 17:39:16 — source: IIUG Forums & Mailing Lists

Hi all IDS 12.1 We have audit records like this: ONLN|2015-09-30 14:32:05.000|Server|20869|db_server|user|0:INRW:database:-1:10485769:268:: -1 should be a tabid, 10485769 should be a partnum of a fragment. Looked up database:systables, database:sysfragments, sysmaster:systabnames, sysmaster systabinfo for the partnum. Couldn't find any row. Tabid -1 doesn't help either. How can I determine the table in which a row was inserted? TIA Reinhard

↪ replying to Habichtsberg, Reinhard

WOLFGANG EPPLER — Mon, 02 Nov 2015 07:57:23 — source: IIUG Forums & Mailing Lists

A tabid -1 is recorded in case of temporary tables. But I don't know if there are additional cases. Best regards,

↪ replying to WOLFGANG EPPLER

Habichtsberg, Reinhard — Mon, 02 Nov 2015 08:46:40 — source: IIUG Forums & Mailing Lists

Ok, that explains why I couldn't find the table. Thank you! -----Ursprüngliche Nachricht----- Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Im Auftrag von WOLFGANG EPPLER Gesendet: Montag, 2. November 2015 08:57 An: ids@iiug.org Betreff: Re: Find table from audit record [35980] A tabid -1 is recorded in case of temporary tables. But I don't know if there are additional cases. Best regards, ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.