v视图的授权

例子：
查询v$mystat说明没有查询权限
@>connectscott/1@bi
Connected.
SCOTT@bi>createuser scott3 identified by "1";

User created.

SCOTT@bi>grantcreate session to scott3;

Grant succeeded.

SCOTT@bi>grantcreate view to scott3;

Grant succeeded.

SCOTT@bi>connectscott3/1@bi
Connected.
SCOTT3@bi>createview my_stat as select * from v$mystat;
create view my_stat as select * from v$mystat
                                     *
ERROR at line 1:
ORA-00942: table or view does not exist

SCOTT3@bi>descv$mystat;
ERROR:
ORA-04043: object "SYS"."V_$MYSTAT" does not exist

2、
SYS@bi>grantselect on v_$mystat to scott3;

Grant succeeded.

3、
SCOTT3@bi>descv$mystat;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
SID                                                NUMBER
STATISTIC#                                         NUMBER
VALUE                                              NUMBER

SCOTT3@bi>createview my_stat as select * from v$mystat;

View created.

SCOTT3@bi>select* from user_sys_privs;

USERNAME                       PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
SCOTT3                         CREATE VIEW                              NO
SCOTT3                         CREATE SESSION                           NO

SCOTT3@bi>select* from user_tab_privs_recd;

OWNER                          TABLE_NAME
------------------------------ ------------------------------
GRANTOR                        PRIVILEGE                                GRA HIE
------------------------------ ---------------------------------------- --- ---
SYS                            V_$MYSTAT
SYS                            SELECT                                   NO  NO

SCOTT3@bi>select* from user_role_privs;

no rows selected