Patch fails on remote database because execute privilege is not granted to AVDWUSER on SYS.DBMS_LOB in RSA Identity Lifecycle and Governance
Originally Published: 2017-10-25
Article Number
Applies To
RSA Version/Condition: 7.0.2
Issue
Initialization has failed! Errors found while patching the schema.
In the patch.log:
--------------------------- Dbms_Output Begin --------------------------- No permission to grant select on V_APPSUMMARYINFO to avdwuser ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' No permission to grant select on V_AVR_ESCALATED_EXCEPTIONS to avdwuser ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' No permission to grant select on V_AVR_EXCEPTIONS_4_OWNR_IN_GRP to avdwuser ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' No permission to grant select on V_EXCEPTIONS to avdwuser ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' No permission to grant select on V_NEWEXCEPTIONS to avdwuser ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' No permission to grant select on V_OPENEXCEPTIONS to avdwuser ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' No permission to grant select on V_OPENIGNOREDEXCEPTIONS to avdwuser ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' No permission to grant select on V_OPENINCIDENTEXCEPTIONS to avdwuser ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' No permission to grant select on V_OPENWORKINGEXCEPTIONS to avdwuser ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' --------------------------- Dbms_Output End ---------------------------
Cause
Workaround
GRANT EXECUTE ON SYS.DBMS_LOB TO AVDWUSER; or GRANT EXECUTE ON SYS.DBMS_LOB TO PUBLIC;
Notes
Related Articles
RSA Identity Governance and Lifecycle - 702 Migration fails with ORA-01720: grant option does not exist for 'SYS.DUAL' Number of Views What is the SYS.ORA_TEMP_1_DS_% table sometimes seen in a running query in RSA Identity Governance & Lifecycle Number of Views ORA-39070: "Unable to open the log file" error or ORA-06512: at "SYS.DBMS_SYS_ERROR" and "SYS.DBMS_DATAPUMP" errors when b… Number of Views Upgrade/patch fails with 'ORA-00001: unique constraint (SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST) violated' error in RSA Identity… Number of Views How to create an alternate database user for AVUSER and SYS to perform admin taks or troubleshooting in RSA Identity Gover… Number of Views
Trending Articles
Artifacts to gather in RSA Identity Governance & Lifecycle Oracle 12c TEMP_UNDO_ENABLED parameter for managing GTT UNDO activity in RSA Identity Governance & Lifecycle RSA announces the availability of the RSA SecurID Hardware Appliance 230 based on the Dell PowerEdge R240 Server RSA Authentication Manager 8.9 Release Notes (January 2026) RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
