SQL Language (MOSC)

MOSC Banner

ora-01720 in Oracle 12c when creating a view that includes a select from sys.dual

edited Apr 7, 2020 6:06AM in SQL Language (MOSC) 5 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center