sys@ORCL>conn namm/namm
Connected.
namm@ORCL>CREATE OR REPLACE VIEW stats
2 AS
3 SELECT 'STAT...' || a.name name, b.VALUE
4 FROM v$statname a, v$mystat b
5 WHERE a.statistic# = b.statistic#
6 UNION ALL
7 SELECT 'LATCH.' || name, gets FROM v$latch;
SELECT 'LATCH.' || name, gets FROM v$latch
*
ERROR at line 7:
ORA-01031: insufficient privileges
namm@ORCL>conn /as sysdba
Connected.
sys@ORCL>grant select on v$latch to namm;
grant select on v$latch to namm
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
sys@ORCL>grant select on v_$latch to namm;
Grant succeeded.
sys@ORCL>grant select on v_$mystat to namm;
Grant succeeded.
sys@ORCL>grant select on v_$mystat to namm;
Grant succeeded.
sys@ORCL>conn namm/namm
Connected.
namm@ORCL>CREATE OR REPLACE VIEW stats
2 AS
3 SELECT 'STAT...' || a.name name, b.VALUE
4 FROM v$statname a, v$mystat b
5 WHERE a.statistic# = b.statistic#
6 UNION ALL
7 SELECT 'LATCH.' || name, gets FROM v$latch;
View created.