Auditing Table Access

Look into using an "Audit Trail". See "Informix-Online Dynamic Server Trusted Facility Manual" Hope this helps! Cheryl L. Kendricks vnibs2@heb.com --------------------------( Forwarded letter 1 follows )--------------------- Date: Thursday, 27 February 1997 9:55am MIME-Version: 1.0 Date:Thu, 27 Feb 1997 08:30:59 -0600 From: James_T_Ford@fleet.com To: informix-list@rmy.emory.edu Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Description: cc:Mail note part Sender: informix-list-owner@rmy.emory.edu Reply-To: James_T_Ford@fleet.com (James T Ford) X-Informix-List-Id: <list.13341> I don't believe this is possible but I figured I'd ask anyways. The problem: Our users connect from PC's via various tools. We have security levels implemented on some of our tables. I would like to be able to run a daemon that will trap whenever a user tries to access data that they are not allowed to (sqlerr 272). Anyone have any ideas on how to accomplish this other than requesting the source code for ODS from informix? Engines online 7.20.UC3 XPS 8.10 Sunos 5.5.1 - cluster Sunos 5.5.1 - stand alone 6000 thanx in advance jim james_t_ford@fleet.com