title: PLSQL Granted privilege to user, but still unable to modify data
body: <p>I have two schemas, and one schema needs to modify data in the other schema. To facilitate this, I have granted privileges to the table as SYSDBA:</p>
  
  <pre><code>GRANT INSERT, UPDATE, DELETE, SELECT ON schema1.mytable TO schema2;
  EXIT;
  </code></pre>
  
  <p>This returns the message <code>Grant succeeded.</code></p>
  
  <p>However, when schema2 tries to do an update on schema1, I get a permissions error telling me that I do not have the privileges to do an update. I took a look at the <strong>grants</strong> tab in <code>mytable</code> in SQLPLUS, and it apparently shows that I don't have privileges:</p>
  
  <pre><code>PRIVILEGE   GRANTEE  GRANTABLE    GRANTOR    OBJECT_NAME
  INSERT       schema2    No         schema1     mytable
  UPDATE       schema2    No         schema1     mytable
  SELECT       schema2    No         schema1     mytable
  DELETE       schema2    No         schema1     mytable
  </code></pre>
  
  <p>How is this possible?</p>