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.
Example:
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.
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.
Example:
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.
Post a Comment
Post a Comment