RE: getting user information in a trigger

Posted in 2000

mosserp@WellsFargo.COM — Wed, 3 May 2000 23:39:41 -0700 — source: Informix-list mailing list archive (1991-1998)

Try the Informix Trusted Facility -- strange name for Informix's audit logging utility. For IDS.2000 (9.2x), look at http://www.informix.com/answers/english/docs/92ids/6214.pdf For 7.3x, check out http://www.informix.com/answers/english/docs/73ids/4348.pdf It's available for 7.2x also. HTH, Paul Mosser -----Original Message----- From: Greg Starnes [mailto:gstarnes@ep-services.com] Sent: Tuesday, April 25, 2000 10:57 AM To: informix-list@iiug.org Subject: getting user information in a trigger im building a trigger to audit user activity in certain tables. Is there a way to query the system to determine a user id that is performing some activity on a table?