授權某使用者，檢視動態效能檢視的許可權（如v$latch,v$lock,v$sqlarea,v$sql,v$sysstat）

 

授權某使用者，檢視動態效能檢視的許可權（如v$latch,v$lock,v$sqlarea,v$sql,v$sysstat）

 

解決方法：grant select any dictionary to doudou;

 

doudou@TEST> desc sys.v$latch

ERROR:

ORA-04043: object sys.v$latch does not exist

 

 

doudou@TEST> desc v$sqlarea

ERROR:

ORA-04043: object "SYS"."V_$SQLAREA" does not exist

 

 

doudou@TEST> desc v$sql

ERROR:

ORA-04043: object "SYS"."V_$SQL" does not exist

 

 

doudou@TEST> desc v$sysstat

ERROR:

ORA-04043: object "SYS"."V_$SYSSTAT" does not exist

 

 

doudou@TEST> desc v$lock

ERROR:

ORA-04043: object "SYS"."V_$LOCK" does not exist

 

 

doudou@TEST> desc v$sqltext

ERROR:

ORA-04043: object "SYS"."V_$SQLTEXT" does not exist

 

 

doudou@TEST> desc v$process

ERROR:

ORA-04043: object "SYS"."V_$PROCESS" does not exist

 

sys@TEST> grant select any dictionary to doudou;

 

Grant succeeded.

 

doudou@TEST>desc v$latch  [OK問題解決]