>>raise an message and kill the session;

How did you go about killing the session? We have tried a number of
ways and it is not easy to kill your own session.



RE: How to Restric User Sessions
From: [Email Address Removed]
Subject: RE: How to Restric User Sessions
Date: Wed, 31 Dec 2003 11:12:06 -0700

Hi,

Just suggestion:

You may want to create a trigger after logon.

In the trigger, do a query like this

select count(*) into i_count
from v$session
where username= 'username'
and osuser= 'osuser'

if i_count >= 2
--raise an message and kill the session;

Hope it will help

Regards,

Lijie (Lee) Gu
Oracle DBA






Oracle LazyDBA home page