title: After creating a role with grant update user1.table1, I gave grant role to user2, when executing the update I received Error ORA-01031
body: <p>After creating role RL_WRITE and granting the grant update to table user1.table1 to role and granting role to user2 I get insufficient privileges error.</p>
  <pre><code>CREATE ROLE RL_WRITE;
  
  GRANT UPDATE ON user1.table1 TO RL_WRITE;
  
  GRANT RL_WRITE to user2;
  </code></pre>
  <p>logged in as user2, when running the command:</p>
  <pre><code>update user1.table1 set datmov = to_date('18/10/21','dd/mm/yy');
  </code></pre>
  <pre><code>*01031. 00000 -  &quot;insufficient privileges&quot;
  *Cause:    An attempt was made to perform a database operation without
             the necessary privileges.
  *Action:   Ask your database administrator or designated security
             administrator to grant you the necessary privileges*
  </code></pre>
  <p>I don't understand what might be missing.</p>