创建视图需要注意的有关问题

创建视图需要注意的问题

创建视图报错

SQL> 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 v$timer;      from v$statname a, v$mystat b                         *第 3 行出现错误: ORA-01031: 权限不足

?解决办法：授权对象v_$statname，v_$latch，v_$timer， v_$mystat

SQL> grant select on v_$statname to carmot_develop;SQL> grant select on v_$latch to carmot_develop;SQL> grant select on v_$timer to carmot_develop;SQL> grant select on v_$mystat to carmot_develop;

?