job呼叫過程報錯 ORA-00942: table or view does not exist
問題描述:
A使用者下建立一個儲存過程proc_1。該儲存過程需要訪問使用者B下的表t1
create table t1 as select * from B.t1
使用者A執行proc_1儲存過程可以成功,但是使用job呼叫該儲存過程報錯ORA-00942:table or view does not exist
問題分析:
儲存過程被job呼叫期間失去了所屬使用者A的許可權(訪問使用者B的表)
解決方法:
1. 顯示授權。應用程式維護人員喜愛這種簡單有效的方法。
grant select any table to A;
2. 在儲存過程中新增關鍵字
CREATE OR REPLACE PROCEDURE proc_1 (name VARCHAR2) Authid Current_User
AS
BEGIN
EXECUTE IMMEDIATE 'SET ROLE ALL';
...
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29047826/viewspace-1607104/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00942: table or view does not existView
- PL/SQL: ORA-00942: table or view does not existSQLView
- imp 時出現在ORA-00942: table or view does not existView
- from v * ERROR at line 1: ORA-00942: table or view does not existErrorView
- GoldenGate 執行ddl_setup.sql出錯 ORA-00942: table or view does not existGoSQLView
- 啟動OEM時關於ora-00942:table or view does not exist的處理View
- SNMP TABLE ERROR : Requested table is empty or does not existError
- MySQL 5.7啟動資料庫報錯'does not exist or is not executable'MySql資料庫
- [BUG反饋]子查詢報錯,Base table or view not found: 1146 Table 'onethink.(' doesn't existView
- oracle for linux安裝報錯 file /home/oracle/.Xauthority does not existOracleLinux
- expdp ORA-31626: job does not exist 解決方案
- jdbc使用call呼叫儲存過程報錯JDBC儲存過程
- Oracle ORA - 01720 grant option does not exist for..報錯解決Oracle
- MySQL 啟動報錯 Table 'mysql.plugin' doesn't existMySqlPlugin
- job呼叫儲存過程的注意事項儲存過程
- asmcmd does not exist in directoryASM
- SAP MM 對採購訂單執行收貨,報錯 - Table T169P entry ZNMI does not exist -
- yii2接入pgSQL(查詢不到表The table does not exist: {{%user}})SQL
- javax.media does not existJava
- Hadoop的mapreduce出現問題,報錯The auxService:mapreduce_shuffle does not existHadoopUX
- kettle工具從windows移植到linux上啟動報錯:\karaf/deploy does not existWindowsLinux
- 11.2通過資料庫鏈呼叫10.2過程報錯資料庫
- ora-00942 儲存過程???儲存過程
- Eclipse裡Tomcat報錯:Document base ……does not exist or is not a readable directory(圖文詳解)...EclipseTomcat
- MIRO Error:Table T169V: entry G180 does not existError
- Flutter開發-iOS報錯Trying to embed a platform view but the PrerollContext does not sFlutteriOSPlatformViewContext
- 通過oracle dbms_job建立tableOracle
- ABAP 資料結構啟用時的錯誤訊息 - combination reference table field does not exist資料結構
- 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
- Gather_stats_job 呼叫dbms_stats.gather_database_stats_job_proc過程來收集statistics 的資訊Database
- The operation, ‘DecodeJpeg/contents‘, does not exist in the graph.錯誤解決方法
- The file '/MasterPage.master' does not exist. 類錯誤解決方法AST
- PSQLexception: ERROR : type "signed" does not existSQLExceptionError
- Laravel Class env does not exist 問題排查Laravel
- FAQ:Field DATABASE does not exist; see long textDatabase