title: Privilege to call DBMS_MVIEW.REFRESH for a materialized view of an other schema
body: <p>I'm currently trying to refresh a materialized view of a schema MYSCHEMA with an other schema (MYSCHEMA_DML). When I try to call</p>
  <p><code>BEGIN DBMS_MVIEW.REFRESH('MYSCHEMA.MV_MYVIEW');END;</code></p>
  <p>I've got the following erreor in my output :</p>
  <pre><code>ORA-06512: à &quot;SYS.DBMS_SNAPSHOT_KKXRCA&quot;, ligne 3020
  ORA-06512: à &quot;SYS.DBMS_SNAPSHOT_KKXRCA&quot;, ligne 2432
  ORA-06512: à &quot;SYS.DBMS_SNAPSHOT_KKXRCA&quot;, ligne 88
  ORA-06512: à &quot;SYS.DBMS_SNAPSHOT_KKXRCA&quot;, ligne 253
  ORA-06512: à &quot;SYS.DBMS_SNAPSHOT_KKXRCA&quot;, ligne 2413
  ORA-06512: à &quot;SYS.DBMS_SNAPSHOT_KKXRCA&quot;, ligne 2976
  ORA-06512: à &quot;SYS.DBMS_SNAPSHOT_KKXRCA&quot;, ligne 3263
  ORA-06512: à &quot;SYS.DBMS_SNAPSHOT_KKXRCA&quot;, ligne 3295
  ORA-06512: à &quot;SYS.DBMS_SNAPSHOT&quot;, ligne 16
  ORA-06512: à ligne 1
  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>My user has the following privilege on the view :</p>
  <ul>
  <li>SELECT</li>
  <li>ALTER</li>
  <li>DELETE</li>
  <li>INSERT</li>
  <li>UPDATE</li>
  </ul>
  <p>Obvously, this isn't enough :( I've done some researches and the only privilege I've found to add in order to do the refresh seems to be</p>
  <p><code>GRANT ALTER ANY MATERIALIZED VIEW to MYSCHEMA_DML; </code></p>
  <p>Which seems a little bit to much. Is it any other privilege that I can grant to my user in order to refresh my view ?</p>