Who Access Tablename?

Xuanhai Carmichael

unread,

Jan 15, 2004, 4:28:06 PM1/15/04

to

Is there any way to find out who is accessing a tablename in a
database? Thank you.
Xuanhai
sending to informix-list

Brian Minnick

unread,

Jan 15, 2004, 4:52:49 PM1/15/04

to

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

------_=_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:xcarm...@puyallup.k12.wa.us">mailto:xcarmichael@puyall=
up.k12.wa.us</A>]
 Sent: Thursday, January 15, 2004 4:28 PM
 To: inform...@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

Rajib Sarkar

unread,

Jan 15, 2004, 7:30:28 PM1/15/04

to

--0__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87
Content-type: multipart/alternative;
Boundary="1__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87"

--1__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable

Yes, there is a way ..if you use the onaudit tool supplied with the
product. U can select events u want to audit and get the information ei=
ther
in a ASCII file or you can load the ASCII file into the database to hav=
e a
SQL interface.

Please read the Trusted Facility manual for more information

Thanx much,

Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
T/L : 667-2100

If we all did the things we are capable of doing, we would literally
astound ourselves. -- T. Edison

=

"Xuanhai Carmichael" =

<xcarmichael@puyallup To: <informix-=
li...@iiug.org>
.k12.wa.us> cc: =

Sent by: Subject: Who Access=
Tablename?
owner-informix-list@i =

iug.org =

=

=

01/15/2004 02:28 PM =

=

Is there any way to find out who is accessing a tablename in a
database? Thank you.
Xuanhai
sending to informix-list

=

--1__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

<html><body>
Yes, there is a way ..if you use the onaudit tool supplied with the =
product. U can select events u want to audit and get the information ei=
ther in a ASCII file or you can load the ASCII file into the database t=
o have a SQL interface. 
 
Please read the Trusted Facility manual for more information 
 
Thanx much, 
 
Rajib Sarkar 
Advisory Software Engineer (RAS) 
IBM Data Management Group 
Ph : (602)-217-2100 
Fax: (602)-217-2100 
T/L : 667-2100 
 
If we all did the things we are capable of doing, we would literally as=
tound ourselves. -- T. Edison 
 
<img src=3D"cid:10__=3D88BBE48EDF912...@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "Xuanhai Carmi=
chael" <xcarm...@puyallup.k12.wa.us>">"Xuanhai Carmi=
chael" <xcarm...@puyallup.k12.wa.us>

<ul>
<ul>
<ul>
<ul>"Xuanhai Carmichael" <xcarmichael@=
puyallup.k12.wa.us> 
Sent by: owner-inf...@iiug.org
01/15/2004 02:28 PM</ul>
</ul>
</ul>
</ul>
</td><td width=3D"100%"><img src=3D"cid:20__=3D88BBE48EDF912A878f9e8a93=
df...@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> 
 
 To: <inform...@iiug.or=
g> 
 cc: 
 Subject: Who Access Tablename=
?</td></tr>
</table>
 
 
<tt>  Is there any way to find out who is accessing a tablename in=
a 
database? Thank you. 
 Xuanhai 
sending to informix-list 
</tt>

</body></html>=

--1__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87--

--0__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=88BBE48EDF912A...@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7

--0__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87
Content-type: image/gif;
name="ecblank.gif"
Content-Disposition: inline; filename="ecblank.gif"
Content-ID: <20__=88BBE48EDF912A...@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7

--0__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87
Content-type: image/gif;
name="pic17925.gif"
Content-Disposition: inline; filename="pic17925.gif"
Content-ID: <30__=88BBE48EDF912A...@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK
BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI
TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR
M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG
uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg
zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa2z9EYKBbpb
qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NENQj2jXjmfNgOZDaXb5glRmXQ33
YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4rwxxINMvpFFAz1KOODHiu+4aEw
NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoCWOOUwgltIwAKRxJgbIkJAQZEq0
2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ6ChjCAH3QlhJcT6VWE6FCkfCco
CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3QxhgohNKXJCWv8JQr/PDdaqd6w
2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iImTHEQyqJ4eIxJJoUBc+3CbBuwZE
V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYGnKEFJeGrxUZy8dB8gmAXI/sPvH
ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1WiMmgkPHQRIrwgFuNV90A3doNKT
mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTVIA0yl5ciTovgLuBDKFUDE9aQcw
9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb
jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl
fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA
Ow==

--0__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87--

sending to informix-list

Andy Kent

unread,

Jan 16, 2004, 6:45:06 AM1/16/04

to

(3) Clog up the Newsgroup with piles of HTML and sundry binary.

> 8BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87
> Content-type: multpart/alternative;
> Boundary="1__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87"
>
> 88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87
> Content-type: etc

<snip>

> AH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
> EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR
> RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH

<snip>

>
> sending to informix-list