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 -> Re: select * from V$SESSION from SQL+ but not application

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

From: <sybrandb_at_hccnet.nl>
Date: Sat, 11 Aug 2007 10:51:16 +0200
Message-ID: <u1uqb3h0801s3vnv9qd6oi7bn6juchriim@4ax.com>


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

Original text of this message

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