On Aug 11, 3:55 am, adrian_ang <adrian_..._at_abv.bg> wrote:
> 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
Adrian - I can't try that right now as I don't know the sys password.
But what allows me to see that view from SQL+ but not from an app? I
don't see this being a privilege issue if I can see it from SQL+.
Received on Sat Aug 11 2007 - 04:19:26 CDT
