title: Why error "ORA-01720: grant option does not exist for 'SYS.DUAL'" when there is a Public.Dual?
body: <p>I'm on Oracle 11g, and I do understand the issue of a 3rd-party grant.</p>
  
  <p>But, given that have user1 creating a view "view1" as Select 'foo' from dual. </p>
  
  <p>Then I grant Select on view1 to user2 and I get this error.  </p>
  
  <p>But note the "dual" in the view is not qualified as sys.dual, it's just dual. I would think with a synonym public.dual that the actual "dual" used would be public.dual, not sys.dual, so no 3rd party issue should exist because it's public.</p>
  
  <p>And if sys.dual is the one Oracle assumes in this view, one would think that given the use of dual is common in views, and that granting privs on views to other users is also common--wouldn't thousands of users be reporting this issue? </p>
  
  <p>I do see sporadic posts about this but no real solution except to create another copy of dual for the user creating the view, but this doesn't make sense to me.
  Thanks for any help.  </p>