title: How do I create a user that can create users in Oracle 12c?
body: <p>I have created a user, granted all the privileges you can see in SQL Developer except sysdba and logged in as the new user, but I still cannot create other users.</p>
  
  <p>Here is what I have done so far:</p>
  
  <ol>
  <li><p>Login as local sysdba;</p></li>
  <li><p>Run:</p>
  
  <pre><code>CREATE USER USERA IDENTIFIED BY "PWDpwd123" DEFAULT TABLESPACE TBS1
  TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
  </code></pre></li>
  <li><p>Grant all privileges and roles you can see in SQL Developer to USERA;</p></li>
  <li><p>Login as USERA;</p></li>
  <li><p>Run: </p>
  
  <pre><code> CREATE USER USERB IDENTIFIED BY "pwd321" DEFAULT TABLESPACE TBS2
   TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
  </code></pre></li>
  </ol>
  
  <p>And then I get a <code>ORA-01031 ERROR</code>. What's wrong?
  Many thanks for your help!</p>