OraGenSec Throwing Error"Error while executing SQL: StmtType-G, Stmt-CREATE or Replace SYNONYM CI_MD_TAB_MOD FOR CISADM.CI_MD_TAB_MOD" While Applying Patch - Installing OUAF Version 126.96.36.199.0
(Doc ID 2704028.1)
Last updated on SEPTEMBER 02, 2020
Applies to:Oracle Financial Services Revenue Management and Billing - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
On : 184.108.40.206.0 version, IP - Installation Upgrade Proc
OraGenSec Throwing error while applying patch - Installing OUAF Version 220.127.116.11.0
While applying the patch Installing OUAF Version 18.104.22.168.0 getting below error
- 2020-06-24 13:31:21,144 [main] ERROR (oem.install.OraGenSec) Error while executing SQL: StmtType-G, Stmt-CREATE or Replace SYNONYM CI_MD_TAB_MOD FOR CISADM.CI_MD_TAB_MOD
- 2020-06-24 13:31:21,144 [main] ERROR (oem.install.OraGenSec)
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
This seems to be because of insufficient privileges' to CISREAD and CISUSER schema What we have observed from Database Administration guide 2900 that below mentioned additional grants need to be executed in order to successfully apply the patch
GRANT CREATE SYNONYM TO CIS_USER;
GRANT CREATE SYNONYM TO CIS_READ;
GRANT EXECUTE on DBMS_UTILITY TO CISADM;
CISREAD and CISUSER should not have DDL access. We need to modify OraGenSec to create synonyms using CISADM privileges instead of CISREAD and CISUSER privileges. Issuing grants to CISREAD and CISUSER is becoming an audit issue at Visa. Kindly help us with the solution so that we could apply patches without these additional grants.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document