Re: trigger on user logoff session

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Tue, 26 Jun 2001 04:03:03 -0700
Message-ID: <F001.00337E29.20010626032548@fatcity.com>

> Hello ,
>
> Can I know whether is it possible for me to set up a trigger to activate if
> any user active this in-house logoff function to kick off any user who is
> activate this script ?
>
>
> ALTER TRIGGER CFLOG DISABLE
> /
> UPDATE CFsecurity
> SET LOGON = 'N'
> WHERE STFID = UPPER('&STFID')
> /
> UPDATE CF88LOG
> SET LOGSTS = '1'
> WHERE USRID = UPPER('&STFID')
> /
> ALTER TRIGGER CFLOG ENABLE
>
> All this is our own tables ,in our application we will check whether is
> there a valid user in the table CFsecurity on accessing certain tables ,
> becoz in a environment having more than 300 user if possible , sometime some
> user is being logoff in the application system w/o notice .and it really
> hard for me to trace who is execute this script ?
>
>
>
>
> Raymond Lee
> Infopro Sdn Bhd
> Block B3 Level 8, Leisure Commerce Square
> No. 9, Jalan PJS 8/9 46150 Petaling Jaya
> Selangor , Malaysia
> Tel : 603-78766666 ext : 266 Fax : 603-78761233
> Email : Raymond_at_infopro.com.my

Raymond,

   I am not sure that I fully understand your problem but if you want to check who was brutally logged off a logoff trigger is unlikely to be the best of solutions. Rather, you should register a timestamp when a user logs in, and another one when s/he logs off (in fact, there is nothing to code, the AUDIT statement can do it for you). If the user loses the connection without any proper log off, then you will have only the login timestamp set. Then it's a matter of comparing the list of currently active sessions to the list of connections without a 'logged off' timestamp.

HTH, Stephane Faroult
Oriole
Corporation

---

Performance tools for Oracle ®
http://www.oriole.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jun 26 2001 - 06:03:03 CDT