Oracle-L: Kill a user's session

From: John Baylis <jbaylis_at_CANFOR.CA>
Date: Tue, 16 Jan 1996 08:16:59 -0800
Message-Id: <9601161657.AA28536@alice.jcc.com>

Environment is Oracle 7.1 on NT and wfw 3.1.

Does anyone know of a secure way of allowing a programmer from killing their own oracle session without giving them 'system' privileges or password?

When a programmers is testing their programs and they get hung up for various reasons, it would be nice if they could terminate their session without getting the dba involved.

Has anyone created a program or procedure that would safely switch to a privileged user to display session id's and allow termination of a session?

Thanks in advance for any thoughts!

John Baylis,  Database Administrator           Tel: (604)661-5310
Canadian Forest Products Ltd.                  Fax: (604)661-5440
Vancouver, British Columbia, Canada          eMail:jbaylis_at_canfor.ca


=================================================================

Received on Tue Jan 16 1996 - 11:57:28 CST