GRANTING THE SELECT TO A PARTICULAR VIEW: 

How to grant SELECT access to v$session to other users?

December 18th, 2008 | Tags: Grant, V$session, v_$session

One can’t grant direct access V$session as v$session is a synonym.

SQL> GRANT SELECT ON v$session TO scott;

grant select on v$session to test

*

ERROR at line 1:

ORA-02030: can only select from fixed tables/views

– shows the V$SESSION is a public synonym

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

OWNER OBJECT_TYPE

———————— ——————-

PUBLIC SYNONYM

– shows the object (table/view) the synonym points to

SQL> select table_owner, table_name FROM dba_synonyms where synonym_name = ‘V$SESSION’;

TABLE_OWNER TABLE_NAME

————– ——————————

SYS V_$SESSION

But one can grant access the underlying table/view.