ORA-01720: grant option does not exist for 'HWCUST.H_OKC_REGION_TERRITORY_T'
以APPS登入,執行如下檢視賦許可權語句。
GRANT SELECT ON APPS.H_PM_REGION_TERRITORY_V TO HWCUST ;
報錯:
ORA-01720: grant option does not exist for 'HWCUST.H_OKC_REGION_TERRITORY_T'
ORA-01720: grant option does not exist for 'HWCUST.H_OKC_REGION_TERRITORY_T'
分析: 檢視中含有的基表對於APPS沒有SELECT 許可權, 且需要GRANT OPTION
以HWCUST登入SQLPLUS, 然後將檢視包含的基表許可權賦給APPS (WITH GRANT OPTION) :
GRANT SELECT ON HWCUST.H_OKC_REGION_TERRITORY_T TO APPS WITH GRANT OPTION ;
GRANT SELECT ON HWCUST.H_OKC_REGION_TERRITORY_T TO APPS WITH GRANT OPTION ;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-742267/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle ORA - 01720 grant option does not exist for..報錯解決Oracle
- grant with admin/grant option
- 關於WITH GRANT OPTION
- with grant option與with admin option區別
- 關於GRANT賦權時,WITH GRANT OPTION和WITH ADMIN OPTION的使用
- asmcmd does not exist in directoryASM
- javax.media does not existJava
- the --skip-grant-tables option so it cannot
- Oracle檢視授權(with grant option)Oracle
- 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
- SNMP TABLE ERROR : Requested table is empty or does not existError
- ORA-00942: table or view does not existView
- FAQ:Field DATABASE does not exist; see long textDatabase
- 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
- PL/SQL: ORA-00942: table or view does not existSQLView
- 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 解決方案
- 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
- dcat-admin 表單 Field type [autocomplete] does not exist.
- yii2接入pgSQL(查詢不到表The table does not exist: {{%user}})SQL
- oracle for linux安裝報錯 file /home/oracle/.Xauthority does not existOracleLinux
- expdp ORA-31626: job does not exist 解決方案
- imp 時出現在ORA-00942: table or view does not existView
- 靜默安裝Oracle建庫時報Template General Purpose does not existOracle
- The operation, ‘DecodeJpeg/contents‘, does not exist in the graph.錯誤解決方法