文章出处:
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使用的是别名,所以权限不能直接赋予查询权限,需要赋予源表权限。