grant select on v$statname to scott;
grant select on v$sesstat to scott;
grant select on v$session to scott;
grant select on v$mystat to scott;
如果取消权限, 则如下:
revoke select on v$statname from scott;
revoke select on v$sesstat from scott;
revoke select on v$session from scott;
revoke select on v$mystat from scott;