On Aug 11, 4:51 am, sybra..._at_hccnet.nl wrote:
> On Sat, 11 Aug 2007 07:19:51 -0000, 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
>
> 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
Sybrand - thanks for the tip, it works and I will use it. Are there
related functions for V$SESSION_EVENT and other OWI views?
Received on Sat Aug 11 2007 - 04:46:07 CDT
