Re: Who Access Tablename?
--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-=
list@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>
<p>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.<br>
<br>
Please read the Trusted Facility manual for more information<br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer (RAS)<br>
IBM Data Management Group <br>
Ph : (602)-217-2100<br>
Fax: (602)-217-2100<br>
T/L : 667-2100<br>
<br>
If we all did the things we are capable of doing, we would literally as=
tound ourselves. -- T. Edison<br>
<br>
<img src=3D"cid:10__=3D88BBE48EDF912A878f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "Xuanhai Carmi=
chael" <xcarmichael@puyallup.k12.wa.us>">"Xuanhai Carmi=
chael" <xcarmichael@puyallup.k12.wa.us><br>
<br>
<br>
<table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel=
lpadding=3D"0">
<tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D88BBE48EDF91=
2A878f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al=
t=3D""><br>
</td><td style=3D"background-image:url(cid:30__=3D88BBE48EDF912A878f9e8=
a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img=
src=3D"cid:20__=3D88BBE48EDF912A878f9e8a93df938@us.ibm.com" border=3D"=
0" height=3D"1" width=3D"225" alt=3D""><br>
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"Xuanhai Carmichael" <xcarmichael@=
puyallup.k12.wa.us></font></b><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">01/15/2004 02:28 PM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"100%"><img src=3D"cid:20__=3D88BBE48EDF912A878f9e8a93=
df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"1" face=3D"Arial"> </font><br>
<font size=3D"2"> To: </font><font size=3D"2"><informix-list@iiug.or=
g></font><br>
<font size=3D"2"> cc: </font><br>
<font size=3D"2"> Subject: </font><font size=3D"2">Who Access Tablename=
?</font></td></tr>
</table>
<br>
<br>
<tt> Is there any way to find out who is accessing a tablename in=
a<br>
database? Thank you.<br>
Xuanhai<br>
sending to informix-list<br>
</tt>
</body></html>=
--1__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87--
--0__=88BBE48EDF912A878f9e8a93df938690918c88BBE48EDF912A87
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=88BBE48EDF912A878f9e8a93df938@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__=88BBE48EDF912A878f9e8a93df938@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__=88BBE48EDF912A878f9e8a93df938@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
V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKq
(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