Re: Triggers on Sysmaster tables ...

This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable If you're on V7, you can using the auditing facility to log users=20 connecting to databases=2E The way to do this is: =20 Turn auditing on (onaudit -l 1 -p <dir to put audit files in>)=2E Audit the OPDB event (onaudit -a -u _require -e +OPDB)=2E Consult the Trusted Facility Manual, pages 3-6 on=2E This tells you h= ow=20 to create the table in which to load the audit data=2E Use cron to load the audit data=2E =20 HTH Davin =20 =20 ______________________________ Reply Separator ____________________________= _____ Subject: Triggers on Sysmaster tables =2E=2E=2E Author: MIME {rambabu@sprynet=2Ecom} at INTERNET Date: 11/05/1998 18:22 hi all, =20 I have a unique requirement to log all the users connecting to a=20 server (to a table residing in a monitoring database)once for each=20 successful connection=2E The table should have unique users who were=20 able to connect to the server=2E =20 I have explored the possibility of creating a trigger on the relevant sysmaster tables=2E But as Informix manages the sysmaster database by=20 not using the SQL statements, on which the triggers are built on, I=20 am left with two options =20 a=2E creat a shell/perl script to monitor the users at regular intervals and update the table=2E b=2E create an alarm file for onprobe/oncockpit and have a stored procedure do=20 the same job=2E =20 But I feel both will far less efficient and can often miss the users who=20 connect to the server only for seconds (even if the alarm file/scripts execution=20 interval every few seconds)=2E Is there a better way of getting the job done? =20 =20 I would appreciate any suggestions or solutions, thanks=2E =20 =20 Vj =20 rambabu@sprynet=2Ecom =20 ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --------------InterScan_NT_MIME_Boundary--