title: Execute Immediate fails even with CREATE table grant
body: <p>I have a problem where I am creating a table using the execute immediate command in the stored procedure. However I get the error of "insufficient privileges". I checked other threads and made sure that the user has "CREATE TABLE" privilege granted to it. However I still keep seeing the same error. </p>
  
  <pre><code>SQL&gt; select * from USER_SYS_PRIVS;
  
  USERNAME                       PRIVILEGE                                ADM
  ------------------------------ ---------------------------------------- ---
  MYUSER            CREATE VIEW                              NO
  MYUSER            UNLIMITED TABLESPACE                     NO
  
  SQL&gt; select * from session_privs;
  
  PRIVILEGE
  ----------------------------------------
  CREATE SESSION
  UNLIMITED TABLESPACE
  CREATE TABLE
  CREATE CLUSTER
  CREATE VIEW
  CREATE SEQUENCE
  CREATE PROCEDURE
  CREATE TRIGGER
  CREATE TYPE
  CREATE OPERATOR
  CREATE INDEXTYPE
  
  11 rows selected.
  </code></pre>
  
  <p>The Dummy procedure I created is : </p>
  
  <pre><code>create or replace procedure sp_dummy
     as
     begin
        execute immediate 'Create table Dummy99_99 (Dummy_Field number)';
     end sp_dummy;
     /
  </code></pre>
  
  <p>Detailed error : </p>
  
  <pre><code>ERROR at line 1:
  ORA-01031: insufficient privileges
  ORA-06512: at "MYUSER.SP_DUMMY", line 4
  ORA-06512: at line 1
  </code></pre>
  
  <p>Is there something wrong I am doing ?</p>