title: Unable to create view - insufficient privileges
body: <p>i'm unable to create a view - i'm getting insufficient privileges.
  Workflow -> create role -> grant create view to role -> create user -> add role to user -> try to create view and i get the error. Any help would be greatly appreciated</p>
  
  <p>Created a role </p>
  
  <pre><code>CREATE ROLE enrolment;
  </code></pre>
  
  <p>Granted the below privileges to the role - base table hr.students</p>
  
  <pre><code>GRANT insert, select, update
  ON hr.students
  TO enrolment;
  </code></pre>
  
  <p>Also granted create view privilege to the role</p>
  
  <pre><code>GRANT create view 
  TO enrolment;
  </code></pre>
  
  <p>Created the below user</p>
  
  <pre><code>CREATE USER enrol1
  IDENTIFIED BY pw4321;
  </code></pre>
  
  <p>Granted the role to the account</p>
  
  <pre><code>GRANT enrolment
  TO enrol1;
  </code></pre>
  
  <p>When i try to create the below view on base table hr.students, i'm being told i have insufficient privileges. I can run the select statement on the base table.</p>
  
  <pre><code>CREATE OR REPLACE VIEW vu_student_name
   AS SELECT student_id, lastname
      FROM hr.students;
  </code></pre>