Re: How to terminate user's session ?

From: <chajec_at_nspr.com>
Date: Fri, 01 May 1998 15:23:22 -0600
Message-ID: <6idavq$cbs$1@nnrp1.dejanews.com>

In article <3548FE38.D4ACB87B_at_wayfarer.com>#1/1, Bill Dietrich <bill_dietrich_at_wayfarer.com> wrote:
>
> Using DB 7.3.x:
>
> If a user X is connected to the database, how can I disconnect
> just that user ? There doesn't seem to be any server command
> I can do to drop their session.
>
> Thanks,
>
> Bill Dietrich
> bill_dietrich_at_wayfarer.com
>
>

Bill,

Use

select username, sid, serial# from v$session where username = 'X';

(this will give you the information you need to use in the next command to kill the session.)

then do

alter system kill session 'sid,serial#'; where you replace sid and serial# from the above query.

Hope this helps.

Carl

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 01 1998 - 16:23:22 CDT