RE: Trusted Hosts facility implementation frustration

Posted in 2006

Topics: Performance & Tuning, Security, Permissions & Auditing, Platform-Specific Issues

mosserp@wellsfargo.com — Tue, 4 Apr 2006 14:38:55 -0500 — source: Usenet: comp.databases.informix

> -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of Doug > McAllister@Fidelity Investments > Sent: Tuesday, April 04, 2006 11:33 AM > To: informix-list@iiug.org > Subject: Re: Trusted Hosts facility implementation frustration > > Thanks Jonathan, this helps > I fat-fingered the title here and actually knew it wasn't "trusted > hosts" but my fingers weren't connected to my brain > > 7.31 on a Solaris machine, only using informix userid, no specific aao > or dbsso > > I need to audit a particular column in a particular table and need to > report what user accessed it. I also need to log key information for > each row. Unfortunately, I DO need to audit row-level operations for > my security people to be happy. I need to present them with an audit > report that shows who accessed the specific row. > I am hoping that when I present them with a ton of data, they will > re-think their requirements. > It may be sooner than that -- they may have to re-think it when system performance goes absolutely down the toilet, and users start screaming. When you activate the RDRW (read row) for all users, you will surely bring the system to its knees. We had to fight this issue with the auditors, and were finally able to get concessions on it, after we proved our point. HTH, Paul Mosser

↪ replying to mosserp@wellsfargo.com

david@smooth1.co.uk — 4 Apr 2006 18:32:07 -0700 — source: Usenet: comp.databases.informix

Stick a trigger on the table that logs the change to another table.