ORA-01720: Grant Option Does Not Exist For 'SYS.DUAL' when executing Dbms_wm.commitddl
Last updated on AUGUST 14, 2017
Applies to:Workspace Manager - Version 22.214.171.124 and later
Information in this document applies to any platform.
Getting the following error on an 126.96.36.199 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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms