Re: V$SESSION IN PACKAGE

The owner of the package must have the rights on v$session.

Alan

Stephan Hartmann wrote in message <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 Mon Mar 13 2000 - 00:00:00 CST