create or replace view v_$instance as select * from v$instance;

SQL> get a
  1  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
SQL> @a
 from v$statname a, v$mystat b
                    *
ERROR at line 3:
ORA-01031: insufficient privileges


SQL> !sqlplus -s "sys/sys as sysdba"
grant select on v_$statname to scott;

Grant succeeded.

grant select on v_$mystat to scott;

Grant succeeded.

grant select on v_$latch to scott;

Grant succeeded.

grant select on v_$timer to scott;

Grant succeeded.

exit;

SQL> @a

View created.