ORA-02030: can only select from fixed tables/views
SQL> grant select on sys.x$bh to bss;
grant select on sys.x$bh to bss
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 bss;
Grant succeeded.
这个普通就有了select到 sys.x$bh权限了
对于v$这种情况
SQL> grant select on v$session to bss;
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 bss;
Grant succeeded.
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/633084/viewspace-1027933/ ，如需转载，请注明出处，否则将追究法律责任。
