Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> select * from V$SESSION from SQL+ but not application

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

From: dean <deanbrown3d_at_yahoo.com>
Date: Sat, 11 Aug 2007 07:19:51 -0000
Message-ID: <1186816791.435171.196460@k79g2000hse.googlegroups.com> 





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
Received on Sat Aug 11 2007 - 02:19:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US