Grant SELECT ON V_$SESSION *directly* to the user owning the
procedure - stored procedures do NOT inherit privileges from roles
unless they are AUTHID CURRENT_USER in 8i or above (this is a
FAQ).
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"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:25:39 CDT
