ORA-00942: 表或视图不存在

ORA-00942: 表或视图不存在

SQL> conn hr/***
SQL> select username,sid,serial#,module,action from v$session;

select username,sid,serial#,module,action from v$session

ORA-00942: 表或视图不存在

解决：

sqlplus "sys/*** as sysdba"
SQL> grant select on  gv$session to hr;
grant select on  gv$session to hr
                 *
第 1 行出现错误:
ORA-02030: 只能从固定的表/视图查询

SQL> grant select on  sys.v_$session to hr;

授权成功。

sqlplus "hr/***"
SQL> select username,sid,serial#,module,action from v$session;

USERNAME                              SID    SERIAL# MODULE                                           ACTION
------------------------------ ---------- ---------- ------------------------------------------------ --------------------------------
                                        1          1                                                 
                                        2          1