How do I create a user that can create users in Oracle 12c?
<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>