title: PLSQL : What privilege to create temporary table
body: <p>I would like to create a temporary table in a procedure in a package depending to user A.</p>
  
  <p>I write this : </p>
  
  <pre><code>EXECUTE IMMEDIATE '
    CREATE GLOBAL TEMPORARY TABLE T (....)';
  </code></pre>
  
  <p>I have an error saying : </p>
  
  <pre><code>ORA-01031 : Insufficient privilege 
  </code></pre>
  
  <p>Selecting user_role_privs I can see that user A has this roles :</p>
  
  <pre><code>CONNECT
  DBA
  RESOURCE
  </code></pre>
  
  <p>What role, which is not contained in the previous ones, should I add to solve my problem?</p>
  
  <p>Thanks</p>