Re: select * from V$SESSION from SQL+ but not application

On 11 , 10:19, dean <deanbrow..._at_yahoo.com> wrote:
> Hello all,
>
> I can log in to SQL+ as user A and select * from V$SESSION. However,
> when I try to do the same thing from an application (logged in as same
> user A), I get a table or view does not exist error. The app uses ADO
> to connect.
>
> Any idea what the difference could be?
>
> Thanks
>
> Dean
>
> 9.2i

Connect as SYS and:

grant select on v_$session to application_user;

and after that try again.

select * from sys.V$SESSION Received on Sat Aug 11 2007 - 02:55:14 CDT