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_at_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 - 16:59:34 CET

Original text of this message