Re: Q: Trigger when users connect or disconnect ??

In article <michel.lalonde.72.000F1404_at_sit.ulaval.ca>, michel.lalonde_at_sit.ulaval.ca says...
>
>In article <4l9c9l$7oq_at_news.nstn.ca> dale_at_fox.nstn.ca (Dale) writes:
>>From: dale_at_fox.nstn.ca (Dale)
>>Subject: Q: Trigger when users connect or disconnect ??
>>Date: 20 Apr 1996 00:48:53 GMT
 

>>I want to be able to tell when a user connects or
>>disconnects so that I may go in an clean-up any results sets
>>that were saved in our "temporary" table (used to hold
>>intermediate result sets of queries).
 

>>I believe that I cannot put triggers on the system tables
>>(v$session, etc). Is anyone doing something similar to this?
>>and how?
 

>>Thanks in Advance
>>Babette Dale Underwood (dale_at_fox.nstn.ca)
>
>What we do is :
>
>- time stamp each row in your "temporary table"
>- run a cron job to clean up old timestamped rows
>
>works fine.
>
>Michel lalonde

Sorry, I forgot to mention it is an NT environment and the user cannot be currently connected.

Babette Received on Thu Apr 25 1996 - 00:00:00 CEST