Re: Creating s stored function that can access v$session.

From: Lindsberger Franz <franz.lindsberger_at_siemens.at>
Date: 1997/01/22
Message-ID: <32E61432.64D9@siemens.at>#1/1

David Woakes wrote:
>
> I've been trying to create a stored function which accesses the
> v$session table and failing. I attach a sample of what I've been
> trying to achieve.
>
> First a piece of PL/SQL that reads from the table happily enough.
>
> ....

#########################################

login as "sys" - user and say
GRANT SELECT ANY TABLE TO my_user; or
GRANT SELECT ON V$SESSION TO my_user;
and your procedure will work.
Error results from ORACLEs way of using ROLES in !!stored!! PL/SQL - code.
greetings from AUSTRIA Received on Wed Jan 22 1997 - 00:00:00 CST