RE: Detect obsolete programs and kill them

I haven't tried this, but this is where I'd start. Try looking into an ON_LOGON trigger that would check the PROGRAM column of v$session and executed an ALTER SYSTEM KILL SESSION if it weren't a current program.

I hope this helps. Please reply in the future, to let us know if this works or not.

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo Wellcome

> -----Original Message-----
> From: Rama Malladi [SMTP:rmalladi_at_inteliant.com]
> Sent: Wednesday, September 27, 2000 3:37 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Detect obsolete programs and kill them
>
> Hi,
> Couple of weeks ago, we released a new version of client code to the
> users.
> By mistake some users did not get the new release and continue using the
> old
> ones, which is very harmful to the integrity of the system. All users are
> notified and it is okay now. But to be on the safe side ...
>
> What I want to do now is to detect when a user logs in with the old
> client
> (The V$Session.Program is different for two releases), and automatically
> kill the session.
>
> Anybody has a quick solution to this?
>
> Thank you
> Rama
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rama Malladi
> INET: rmalladi_at_inteliant.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 Fri Sep 29 2000 - 09:01:19 CDT