Re: How to kill a session

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Tue, 1 Oct 2002 05:44:54 -0500
Message-ID: <upiv4sjkak4cac@corp.supernews.com>

You need to as sys to 'grant SELECT ON V_$SESSION to user' without going through a role.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote in message news:anbrfu$r9i$1_at_reader1.imaginet.fr...
> Hi,
> I try to kill a session of a given user name with a procedure.
> My procedur seems to be correct but when I try to read V$SESSION in my
> procedure when I compile, I have error : This tble or this view doesn't
> exist. So i tried to use the real name SYS.V_$SESSION but I've got the
same
> error! So how can I get the SID and Serial of the Session of an user to
kill
> his session. Becaus ALTER SYSTEM KILL SESSION needs those parameters.
>
> Thx
>
>
>
Received on Tue Oct 01 2002 - 05:44:54 CDT