How to kill a session (Script)

Hi,

I need a script that get the SID and serial of aUser and then kill his session.

What's the best way ?

I tried to write a PL/SQL procedure. It works fine to get the SID and SERIAL, but does not work with the ALTER SYSTEM statement. I'm getting the error :

The following error has occurred:

PROCEDURE USER.TEST2
On line: 3
PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:

   begin declare exit for goto if loop mod null pragma raise    return select update while <an identifier>    <a double-

Please don't tell me it is again some kind of ROLE or PRIVILEGE related problem ? :)

What's the best way to handle this (I'm not a specialist) ? Received on Mon Jan 28 2002 - 15:54:58 CET