Granting select access to v$ Tables
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.
Subscribe to:
Post Comments
(
Atom
)
Posts
No comments :
Post a Comment