title: Oracle : Grant select on a View
body: <p>I'm trying to perform a select operation on a view which contains a few tables as follows</p>
  
  <pre><code>SELECT count(1) FROM ABC_DEF.MY_VIEW;
  </code></pre>
  
  <p>The view :</p>
  
  <pre><code>SELECT TEXT FROM DBA_VIEWS where OWNER = 'ABC_DEF' and VIEW_NAME  = 'MY_VIEW' ;
  
  Result : SELECT "COL_1", "COL_2" FROM (SELECT DISTINCT A.COL_1, B.COL_2 FROM ABC.TABLE_1 A, XYZ.TABLE_2 B WHERE A.COL_3 = B.COL_3)
  </code></pre>
  
  <p>In order to do this, I try to grant select access to the role I use</p>
  
  <pre><code>GRANT SELECT ON ABC_DEF.MY_VIEW TO MY_READ_ROLE;
  ERROR at line 1:
  ORA-01720: grant option does not exist for 'XYZ.TABLE_2'
  </code></pre>
  
  <p>Then I try to grant select to the table itself</p>
  
  <pre><code>GRANT SELECT ON XYZ.TABLE_2 TO MY_READ_ROLE;
  
  Grant succeeded.
  </code></pre>
  
  <p>And then I try to perform the grant on the view again, but I still get the same error. Could someone help me with this?</p>