Thursday, July 29, 2010

package body V$SESSION table or view not exist

select NVL(TERMINAL,'UNKNOWN) from V$SESSION where SID = 1;

you can have result from above snippet at sqlplus, but it shows error ORA-00942: table or view does not exist when you access from package body

View name : V_$SESSION
Public synonym known as : V$SESSION

Solution :
connect sys/[password]@[SID] as sysdba

GRANT SELECT ON V_$SESSION TO [username];

OR

GRANT SELECT ANY DICTIONARY TO [username];

0 comments: