RSA Identity Governance and Lifecycle - 702 Migration fails with ORA-01720: grant option does not exist for 'SYS.DUAL'
Originally Published: 2017-11-14
Article Number
Applies To
RSA Version/Condition: 7.0.2
Issue
SQL/line#: /home/oracle/wildfly/domain/servers/server-one/tmp/vfs/temp/tempd214140fae9fc9c9/content-526bdb5a5591db16/contents/aveksa.war/WEB-INF/database/Views/v_av_db_timezone.sql(1):
Start time [Thu Nov 09 13:35:04 EST 2017]
CREATE OR REPLACE FORCE VIEW V_AV_DB_TIMEZONE
AS
SELECT UTILITIES_PKG.GET_DBTIMEZONE_VALUE FROM DUAL
java.sql.SQLSyntaxErrorException: ORA-01720: grant option does not exist for 'SYS.DUAL'
Cause
Post Upgrade To 11.2.0.4, "create or replace view" execution fails with "ORA-01720: Grant Option Does Not Exist" (Doc ID 1628033.1)
Resolution
1. As 'avuser' run this SQL:
drop view v_av_db_timezone;
CREATE OR REPLACE FORCE EDITIONABLE VIEW "AVUSER"."V_AV_DB_TIMEZONE" ("GET_DBTIMEZONE_VALUE") AS
SELECT UTILITIES_PKG.GET_DBTIMEZONE_VALUE FROM DUAL;
2. Enter the migration password in the Initialization Status screen to restart the migration.
Related Articles
Patch fails on remote database because execute privilege is not granted to AVDWUSER on SYS.DBMS_LOB in RSA Identity Lifecy… 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 Upgrade/patch fails with 'ORA-00001: unique constraint (SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST) violated' error in RSA Identity… 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 Error "com.rsa.ims.security.keymanager.sys.MissingSystemKeysException: System fingerprint encrypted key is missing" on RS… Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.9 Release Notes (January 2026) Artifacts to gather in RSA Identity Governance & Lifecycle RSA Governance & Lifecycle 8.0.0 Administrators Guide RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
