title: ORA-01031: insufficient privileges when inserting via dblink
body: <p>This works:</p>
  
  <pre><code>(connect to some_db)
  INSERT INTO some_schema.some_table(id) VALUES (some_schema.some_table.nextval);
  </code></pre>
  
  <p>THis works too:</p>
  
  <pre><code>(connect to some_other_db)
  SELECT some_schema.some_table.nextval@some_db FROM DUAL;
  </code></pre>
  
  <p>This does not work:</p>
  
  <pre><code>(connect to some_other_db)
  INSERT INTO some_schema.some_table@some_db(id) VALUES (some_schema.some_table.nextval@some_db);
  </code></pre>
  
  <p>The error I get is <code>ORA-01031: insufficient privileges ORA-02063: preceding line from SOME_DB</code>. The insert privilege for some_schema.some_table is granted through a default role.</p>
  
  <p>What could be the problem here?</p>
  
  <p><strong>Update:</strong> adding <code>select</code> right for the table made the remote query work.</p>