ORA-01720: Grant Option Does Not Exist For 'SYS.DUAL' when executing Dbms_wm.commitddl
(Doc ID 2296933.1)
Last updated on APRIL 01, 2020
Applies to:Workspace Manager - Version 220.127.116.11 and later
Information in this document applies to any platform.
Getting the following error on an 18.104.22.168 database when executing dbms_wm.commitddl:
ORA-01720: grant option does not exist for 'SYS.DUAL'
SQL> exec dbms_wm.beginddl('enet.t_light_pole')
PL / SQL procedure completed successfully.
SQL> ALTER TABLE ENET.T_LIGHT_POLE_LTS ADD (CHANGESET_ID NUMBER, CHANGE_DAT DATE);
SQL> COMMENT ON COLUMN ENET.T_LIGHT_POLE_LTS.CHANGESET_ID IS 'Id of the last increment that updated or inserted the record';
SQL> COMMENT ON COLUMN ENET.T_LIGHT_POLE_LTS.CHANGE_DAT IS 'Last date of update. For data belonging to legacy systems, it is collected from the source system. At steady speed, this field is automatically updated by incremental procedures';
SQL> exec dbms_wm.commitddl('enet.t_light_pole')
BEGIN dbms_wm.commitddl('enet.t_light_pole'); END;
ERROR at line 1:
ORA-01720: grant option does not exist for 'SYS.DUAL
ORA-06512: a "WMSYS.LT", line 12510
ORA-06512: a line 1
It does not work even using ignore_last_error=true when executing dbms_wm.commitddl, it raises the same error.
Same error raises also after running:
GRANT select ON SYS.DUAL TO PUBLIC with GRANT OPTION;
How do we resolve this?
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