To provide grant select access on v$ tables (like v$session,V$ASM_DISK etc) error will encountered as these are synonyms.

The grant has to be provided on its views like (v_$session,V_$ASM_DISK etc).
After this grant the user can view details from these tables.


grant select on V_$ASM_DISK to hsingh;
grant select on V_$SESSION to hsingh;

connect hsingh/******
select * from v$session;

Now the details will be visible.