例子:
查询v$mystat说明没有查询权限
@>connect scott/1@bi
Connected.
SCOTT@bi>create user scott3 identified by "1";
User created.
SCOTT@bi>grant create session to scott3;
Grant succeeded.
SCOTT@bi>grant create view to scott3;
Grant succeeded.
SCOTT@bi>connect scott3/1@bi
Connected.
SCOTT3@bi>create view 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>desc v$mystat;
ERROR:
ORA-04043: object "SYS"."V_$MYSTAT" does not exist
2、
SYS@bi>grant select on v_$mystat to scott3;
Grant succeeded.
3、
SCOTT3@bi>desc v$mystat;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
STATISTIC# NUMBER
VALUE NUMBER
SCOTT3@bi>create view 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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27038344/viewspace-748749/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27038344/viewspace-748749/