RE: Who Access Tablename?

Posted in 2004

Brian Minnick — Thu, 15 Jan 2004 16:52:49 -0500 — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C3DBB1.EAD88AA0 Content-Type: text/plain; charset="iso-8859-1" Check who is processing sqls. onstat -g sqland note the session ids Check each of these sessions. onstat -g ses ses_id This will show the sql code being processed and the user_id. -----Original Message----- From: Xuanhai Carmichael [mailto:xcarmichael@puyallup.k12.wa.us] Sent: Thursday, January 15, 2004 4:28 PM To: informix-list@iiug.org Subject: Who Access Tablename? Is there any way to find out who is accessing a tablename in a database? Thank you. Xuanhai sending to informix-list ------_=_NextPart_001_01C3DBB1.EAD88AA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2654.45"> <TITLE>RE: Who Access Tablename?</TITLE> </HEAD> <BODY> Check who is processing sqls. onstat -g sql and note the session ids Check each of these sessions. onstat -g ses ses_id This will show the sql code being processed and the = user_id. -----Original Message----- From: Xuanhai Carmichael [<A = HREF=3D"mailto:xcarmichael@puyallup.k12.wa.us">mailto:xcarmichael@puyall= up.k12.wa.us</A>] Sent: Thursday, January 15, 2004 4:28 PM To: informix-list@iiug.org Subject: Who Access Tablename?   Is there any way to find out who is accessing = a tablename in a database? Thank you.   Xuanhai sending to informix-list </BODY> </HTML> ------_=_NextPart_001_01C3DBB1.EAD88AA0-- sending to informix-list

RE: Who Access Tablename?

Related threads

Your privacy choices