| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> Cannot read from sys.v_$session
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
![]() |
![]() |