Re: When Does a User Die ?

Phil.Holt_at_labsystems.fisons.co.uk (Phil Holt) wrote:

When the breath leaves their body and the heart stops beating....

Sorry couldn't pass that one up, the title got me going...

>How can I detect when a user exits or there process is killed by
>network failure or some other tragic event. Oracle's suggestion is to
>copy the audit tables from sys to system and then use triggers to
>detect the logon logoff actions. For various reasons I can't use this
>method and need to find some other way.
>One Idea is to create a user lock when the user connects to the
>database which will be cleared when the user process dies but I can
>only detect this by polling and ideally I would like a signal or
>trigger. Can anyone help ?
>One last constraint, the application has to be portable so I have to
>use PL/SQL and not C.
>

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP
25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555
Email gordonh_at_acslink.net.au
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ It is far far better to remain silent and appear a fool then to open ones mouth and remove all doubt.

Anon. Received on Mon Dec 04 1995 - 00:00:00 CET