RE: Trusted Hosts facility implementation frustration

#1 (**permalink**) 04-20-2008, 11:53 AM

> -----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

#2 (**permalink**) 04-20-2008, 11:53 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode