ORA-00942: table or view does not exist
今天執行一個 procedure 突然報錯:這個procedure 不合法.這個都執行好幾年了的procedure 怎麼突然報錯,難道什麼物件被刪除了.如是編輯它,發現報錯的語句是這句:
select count(1) into cout from dba_tables where table_name = 'XXSXX';
這個 dba_tables 不是系統自帶的檢視嘛,怎麼會報找不到了.如是向高手們請教,大家給我支招如下
方法一 建立 同義詞 並授權:
create synonym test.dba_tables for sys.dba_tables;
grant select on test.dba_tables to test;
方法二 直接授權
grant select on sys.dba_tables to test;
或者
grant select any dictionary to test;
下面這句是把資料字典的查詢許可權都賦予指定使用者,而上面的授權,需要一個個檢視授權了.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9399028/viewspace-746800/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- PL/SQL: ORA-00942: table or view does not existSQLView
- imp 時出現在ORA-00942: table or view does not existView
- job呼叫過程報錯 ORA-00942: table or view does not existView
- from v * ERROR at line 1: ORA-00942: table or view does not existErrorView
- 啟動OEM時關於ora-00942:table or view does not exist的處理View
- GoldenGate 執行ddl_setup.sql出錯 ORA-00942: table or view does not existGoSQLView
- SNMP TABLE ERROR : Requested table is empty or does not existError
- asmcmd does not exist in directoryASM
- yii2接入pgSQL(查詢不到表The table does not exist: {{%user}})SQL
- javax.media does not existJava
- MIRO Error:Table T169V: entry G180 does not existError
- MIGO Error:Check table 169P: entry G180 does not existGoError
- Property [title] does not exist on this collection instance
- Waring: /dev/centos/swap does not existdevCentOS
- PatchObject constructor:Input file does not existObjectStruct
- PSQLexception: ERROR : type "signed" does not existSQLExceptionError
- Laravel Class env does not exist 問題排查Laravel
- FAQ:Field DATABASE does not exist; see long textDatabase
- Check table 169P: entry XXXX does not exist的解決
- [BUG反饋]子查詢報錯,Base table or view not found: 1146 Table 'onethink.(' doesn't existView
- relation with OID 637165 does not exist
- ORA-04043: object DBA_DATA_FILES does not existObject
- ORA-04042 procedure, function, package, or package body does not existFunctionPackage
- ORA-24756: transaction does not exist問題解決
- 【Oracle】-【許可權-ORA-04043】- object does not existOracleObject
- ORA-12545 TNS: Host or Object Does not ExistObject
- Property 'context' does not exist on type 'NodeRequire'.ts(2339)ContextUI
- The user specified as a definer ('wx_root'@'%') does not exist 解決方案
- view the favorites table.View
- ABAP 資料結構啟用時的錯誤訊息 - combination reference table field does not exist資料結構
- 'mysql.column_stats' doesn't exist and Table 'mysql.index_stats' doesn't existMySqlIndex
- MySQL 5.7啟動資料庫報錯'does not exist or is not executable'MySql資料庫
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解決方法MySql
- org.apache.maven.plugins:maven-archetype-plugin does not existApacheMavenPlugin
- 模擬ORA-04043並解決(dba_* does not exist)
- The subkey 'HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesAVP' does not exist on the 'localhost'Maclocalhost
- SAP MM 對採購訂單執行收貨,報錯 - Table T169P entry ZNMI does not exist -
- MYSQL ERROR 1146 Table doesnt exist 解析MySqlError