ORACLE创建视图提示ORA-01031: insufficient privileges

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$latch;

 

 

ORA-01031: insufficient privileges 为权限不足错误，需给用户授权查看任何字典的权限

 

grant select any dictionary to test;