Shulou(Shulou.com)06/01 Report--

Recently, when I was watching Thomas Kyte, when I customized the environment, I ran the following script: scott@SHENZHEN > grant select any table to scott; scott@SHENZHEN > create or replace view stats as select 'STAT...' | | a.name name, b.value from v$statname a, v$mystat b where a.statistic# = b.statistic# union all select' LATCH.' | | name, gets from v$latchlatch union all 9 select 'STAT...Elapsed Time', hsecs from v$timer From v$statname a, v$mystat b * ERROR at line 3:ORA-01031: insufficient privileges [@ more@] wants to assign the select permissions of these dynamic performance views to Scott:sys@SHENZHEN > grant select on v$mystat to scott; grant select on v$mystat to scott * ERROR at line 1:ORA-02030: can only select from fixed tables/views query and finds that the original v$ object is not a view, but a synonym for the vdesktop $view, which is created based on the real v$ view. There is also the X$ table, which is the basis for running the Oracle database and is dynamically created by the Oracle application when the database starts. This part of the table is critical to the database, so Oracle does not allow direct access by users other than SYSDBA, showing that authorization is not allowed. Assign select permissions to the 4 vested $views sys@SHENZHEN > grant select on v_$mystat to scott;Grant succeeded.sys@SHENZHEN > grant select on v_$statname to scott;Grant succeeded.sys@SHENZHEN > grant select on v_$latch to scott;Grant succeeded.sys@SHENZHEN > grant select on v_$timer to scott Grant succeeded.scott@SHENZHEN > create or replace view stats 2 as select 'STAT...' | | a.name name, b.value 3 from v$statname a, v$mystat b 4 where a.statistic# = b.statistic# 5 union all 6 select' LATCH.' | | name, gets 7 from v$latch 8 union all 9 select 'STAT...Elapsed Time', hsecs from vastly timeristView created. Problem solved! Reference: http://space.itpub.net/9252210/viewspace-591741http://www.orafaq.com/forum/t/72902/2/http://zhangsolomon.itpub.net/post/39913/488842http://blog.csdn.net/yang073402/archive/2010/04/13/5482987.aspxhttp://www.alidw.com/?p=263

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.