ORACLE ORA02030: can only select from fixed tables/views

sys@ORCL> grant select on v$timer to test;

 grant select on v$timer to test                

 *

ERROR at line 1:

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

分析:对以v$开头的视图,不能直接grant

v$开头的视图是v_$的同义词

如v$timer是v_$timer的同义词

sys@ORCL> grant select on v_$timer to test;

Grant succeeded.

原文地址:https://www.cnblogs.com/cangos/p/2317285.html