Insufficient privilege
An issue I found on a similar problem was that the ‘first’ grant on the object had to be done ‘with grant option’.

Eg for the issue above, this would therefore mean:

GRANT SELECT ON &lt;underlying table owner&gt;.&lt;table_name&gt; TO CST0 WITH GRANT OPTION;


Then running

GRANT SELECT ON &lt;schema&gt;.&lt;view_name&gt; TO CST0;


should work.

Note this this ‘foundation’ grant will need to be repeated for each of the underlying table owner>. which forms part of the view definition.