ORA-01720: Grant Option Does Not Exist For 'SYS.DUAL' when executing Dbms_wm.commitddl (Doc ID 2296933.1)

Last updated on AUGUST 14, 2017

Applies to:

Workspace Manager - Version 11.2.0.4 and later
Information in this document applies to any platform.

Goal

Getting the following error on an 11.2.0.4 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);
Table modified.

SQL> COMMENT ON COLUMN ENET.T_LIGHT_POLE_LTS.CHANGESET_ID IS 'Id of the last increment that updated or inserted the record';
Created comment.

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';
Created comment.

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?
 

Solution

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