ONAUDIT or trigger & st.or. procedure

Posted in 2004

Topics: Stored Procedures & SPL, Security, Permissions & Auditing, Triggers, Constraints & Referential Integrity

Nebojsa Sevo — Thu, 26 Feb 2004 08:28:33 +0100 — source: Usenet: comp.databases.informix

My customer have request to monitor update / delete activities on some tables. I read Trusted Facility Manual. Problem with onaudit utility is that its output is not "human readable" and it can't work on table level. I know how to get table name from tabid and how to get data from rowid but I am not sure that it is right way. If I will use triggers and stored procedures problem is that I have to change them every time I change table definition. If anybody has experience with "monitoring DB activity" or suggestions, please share it with me. Thanks in advance Nebojsa ------------------------------------ Remove spam block (DELETE_) to reply

↪ replying to Nebojsa Sevo

Steve — Thu, 26 Feb 2004 10:50:19 +0100 — source: Usenet: comp.databases.informix

Hi Nebojsa, which Informix-Version ? Steve Nebojsa Sevo schrieb: > My customer have request to monitor update / delete activities on some tables. I > read Trusted Facility Manual. Problem with onaudit utility is that its output is > not "human readable" and it can't work on table level. > I know how to get table name from tabid and how to get data from rowid but I am > not sure that it is right way. > If I will use triggers and stored procedures problem is that I have to change > them every time I change table definition. > If anybody has experience with "monitoring DB activity" or suggestions, please > share it with me. > > Thanks in advance > > Nebojsa > ------------------------------------ > Remove spam block (DELETE_) to reply -- Ihre bevorzugten Shops, hilfreiche Einkaufs-Hilfen und gro'artige Geschenk Ideen. Erleben Sie das Vergn'gen online einzukaufen mit Shop@Netscape! http://shopping.netscape.de/shopping/