Remote IT Support!! Please contact us

For Any Remote Support,Implementation/Upgrade Projects,Queries,Collaborations please mail us at

Granting select access to v$ Tables

No comments
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.

No comments :

Post a Comment