转载- 如何将V$表查询权限（V$session）

文章出处：

http://blog.itpub.net/17179887/viewspace-665506/

SQL> SELECT owner, object_type FROM dba_objects WHERE object_name = ‘V$SESSION’;

OWNER OBJECT_TYPE
———————— ——————-
PUBLIC SYNONYM
SQL> select table_owner, table_name FROM dba_synonyms where synonym_name = ‘V$SESSION’;
TABLE_OWNER TABLE_NAME
————– ——————————
SYS V_$SESSION
SQL> GRANT SELECT ON V_$SESSION TO scott;
Grant succeeded.
备注：因为V$session使用的是别名，所以权限不能直接赋予查询权限，需要赋予源表权限。