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

lovehewenyu發表於2012-09-10

 

授權某使用者,檢視動態效能檢視的許可權(如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問題解決]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26442936/viewspace-743071/,如需轉載,請註明出處,否則將追究法律責任。

相關文章