ora-01720 in Oracle 12c when creating a view that includes a select from sys.dual
I have this create view statement that is failing with ORA-01720: grant option does not exist for 'SYS.DUAL' on line 7
create or replace view v_decisions
(Sort_No, Name, Abbreviation, Include_In_EM, WPSetup_ID, Include_In_MBP, Web_Name )
as
select Sort_No, Name, Abbreviation, Include_In_EM, WPSetup_ID, Include_In_MBP, Web_Name
from decision
union
select -2, 'Inquiry', 'INQ', 'N', null, 'N', null from dual
union
select -1, 'Applicant', 'APP', 'N', null, 'N', null from dual
;
The user was created by the sys user as sysdba and given the select on sys.dual with this statement.