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博客 ” ，链接：http://blog.itpub.net/633084/viewspace-1027933/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/633084/viewspace-1027933/