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 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
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Release Notes for RSA Authentication Manager 8.8 RSA Authentication Manager 8.9 Release Notes (January 2026) Supported On-Demand Authentication (ODA) SMS providers for use with RSA Authentication Manager 8.x Deploying RSA Authenticator 6.2.2 for Windows Using DISM
Don't see what you're looking for?
