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

On Sat, 11 Aug 2007 07:19:51 -0000, dean <deanbrown3d_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

Why do you need that? Are you aware you can get session information using the SYS_CONTEXT function, without such kludges as described by the other poster?

-- 
Sybrand Bakker
Senior Oracle DBA