Re: V$SESSION IN PACKAGE

From: Olivier Franssen <olivier.franssen_at_be.norkom.com>
Date: 2000/03/14
Message-ID: <y9rz4.34373$mZ5.40658@afrodite.telenet-ops.be>#1/1

You should grant select on v$session directly to the user test, because stored procedures do not get the grants via roles.

Cheers,
Olivier

"Stephan Hartmann" <Stephan_Hartmann_at_t-online.de> wrote in message news:8ajnnh$541$1_at_news08.btx.dtag.de...
> Hello,
>
> I have create a user TEST, granted them the plustrace role (because of
> V$SESSION).
>
> When I make a simple SQL-Statement SELECT * FROM V$SESSION everything
works
> fine.
>
> When I try to access the V$SESSION View from inside a package
> I get an error PSL-00201, SYS.V_$SESSSION must be declared.
>
> What is missing, or how is it possible to access the V$Session View ?
>
> bye
> Stephan
>
>
>
Received on Tue Mar 14 2000 - 00:00:00 CST