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>
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