Re: How to kill a session

From: Mike Ault <mikerault_at_earthlink.net>
Date: 1 Oct 2002 08:06:24 -0700
Message-ID: <37fab3ab.0210010706.34059a0f@posting.google.com>

We have a white paper on www.robonerd.com in the downloads discussion area about Killing Oracle processes. It might help. The others have already told you about your permission problem. I call it the store object developers mantra:

"I cannot create stored objects with grants from role, all grants for objects used in stored code must be direct grants"

Mike

"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 - 10:06:24 CDT