對于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.

總結

以上是生活随笔為你收集整理的ORACLE ORA-02030: can only select from fixed tables/views的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。