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

Home -> Community -> Usenet -> comp.databases.oracle -> Cannot read from sys.v_$session

Cannot read from sys.v_$session

From: Chris Jack <chris_jack_at_msn.com>
Date: 15 Jan 2004 07:59:34 -0800
Message-ID: <648c9f62.0401150759.7f571f6b@posting.google.com>

I have done the following as dbo:

grant select on sys.v_$session to dbo;
create or replace view z as select * from sys.v_$session ;

But the second command gives me:
ERROR at line 1:
ORA-00942: table or view does not exist

I can select directly from sys.v_$session by select * from sys.v_$session;

What do I have to do/grant permission wise to be able to create a view or PL/SQL function which accesses sys.v_$session?

Regards
Chris (chris_jack_at_msn.com) Received on Thu Jan 15 2004 - 09:59:34 CST

Original text of this message

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