Re: How to terminate user's session ?

From: Venkat <vreddy_at_ix.netcom.com>
Date: Thu, 30 Apr 1998 19:52:44 -0400
Message-ID: <6ib30b$4e@sjx-ixn2.ix.netcom.com>

ALTER SYSTEM KILL SESSION 'sid, serial#' (the sid and serial# are from v$session table. The sid and serial# are enclosed in quotes separated by a comma)

Venkat

>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
>
>
Received on Thu Apr 30 1998 - 18:52:44 CDT

This message: [ Message body ]
Next message: Alan Campbell: "Re: Poor documentation choice in HTML"
Previous message: Ed Jennings: "Auditing - Capture Select Statements"
In reply to: Bill Dietrich: "How to terminate user's session ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US