授權某使用者,檢視動態效能檢視的許可權(如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問題解決]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26442936/viewspace-743071/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- v檢視的授權
- v$sql檢視和v$sqlarea檢視的構建SQL
- Oracle動態效能檢視學習之v$sqltext & v$sqlareaOracleSQL
- oracle v$sysstat效能檢視Oracle
- v$sqlarea,v$sql,v$sqltext三個檢視的區別SQL
- Oracle中效能檢視V$SYSSTATOracle
- V$SQLAREA 檢視TOP_SQLSQL
- v$sesstat,v$mystat,v$statname和v$sysstat檢視簡介
- 檢視 v$sql,v$sqlarea,$sqltext,v$sqltext_with_newlines 的差異SQL
- Oracle動態效能檢視學習之v$lock & v$locked_objectOracleObject
- V$PGASTAT動態效能檢視AST
- Oracle動態效能檢視學習筆記(1)_v$sysstatOracle筆記
- V$SQL、V$SQLSTATS、V$SQLAREASQL
- 11g新動態效能檢視V$SQL_MONITOR,V$SQL_PLAN_MONITORSQL
- [ZT]v$sqlarea,v$sql,v$sqltext這三個檢視提供的sql語句有什麼區別SQL
- 動態效能表V$sysstat
- Oracle動態效能檢視學習筆記(2)_v$sesstat_v$mystat_v$statnameOracle筆記
- Oracle的v$動態檢視 收藏Oracle
- 幾個檢視 v$mystat v$systata v$sessionSession
- 【Oracle九大效能檢視】之2.v$sqlarea_查效能SQLOracleSQL
- v$sql,v$sqlarea,v$sqltext區別SQL
- V$sql_text v$sqlarea v$sql 的區別SQL
- v$session 檢視Session
- V$PGA_TARGET_ADVICE 動態效能檢視
- v$動態效能檢視和隱含引數
- 學習動態效能表(11)--v$latch$v$latch_children
- 使用V$SQL_PLAN檢視SQL
- v$sql_plan 檢視解析SQL
- V$SQL 和V$SQLAREA區別SQL
- v$sql和v$sqlarea的區別SQL
- (轉):學習Oracle動態效能表-(7)-V$SQLTEXT,V$SQLAREAOracleSQL
- [轉]學習Oracle動態效能表-(6)-V$SQLTEXT,V$SQLAREAOracleSQL
- (轉)Oracle動態效能檢視學習之v$processOracle
- Oracle動態效能檢視學習之 V$ROLLSTAT -- 轉Oracle
- v$sqlarea,v$sql,v$sqltext的區別和聯絡SQL
- Oracle常用的V$檢視Oracle
- 效能檢視 V$Session_LONGOPSSessionGo
- (轉):學習Oracle動態效能表-(11)-v$latch$ v$latch_childrenOracle