ORACLE ORA-02030: can only select from fixed tables/views

对于x$的情况

SQL> grant select on sys.x$bh to t1;

grant select on sys.x$bh to t1

ERROR at line 1:

ORA-02030: can only select from fixed tables/views

对于fixed tables/views只能select

如果想把x$bh的select权限grant给其他用户怎么办呢,可以变通一下

SQL> create view xbh as select * from sys.x$bh;

View created.

SQL> grant select on xbh to t1;

Grant succeeded.

这个普通用户t1就有了select到 sys.x$bh权限了

对于v$的情况

SQL> grant select on v$session to t1;

grant select on v$session to bss

*

ERROR at line 1:

ORA-02030: can only select from fixed tables/views

SQL> grant select on v_$session to t1;

Grant succeeded.