problem with select from v$session

Hi,
Most of the questions which i have been posting on this news group have not been answered but still i am trying to solve my problem through this channel.

My problem is that i have a user with the following roles

1.resource
2.connect
3.dba

If from the sqlplus i query the view v$session it gives me the result but if the same select statement inside a stored procedure it says v$session not declared. Now if i grant select any table to this user then the stored procedure is compiling fine.

Can somebody clear my confusion as to why from the sqlplus the query got executed and why not from the stored procedure.

I hope that there is atleast somebody there who is ready to help me.

Thanks
anurag

also reply at
anurag_at_synergy-infotech.com Received on Fri Aug 06 1999 - 02:19:14 CDT