Why cann't I select from v_$session under system?
SQL> connect / as sysdba
Connected.
SQL> grant select on v_$session to system;
Grant succeeded.
SQL> connect system/oracle
Connected.
SQL> select * from v_$session;
select * from v_$session
*
ERROR at line 1:
ORA-00942: table or view does not exist




Reply With Quote