title: oracle apex public user admin privilege to perform some specific action
body: <p>It is the requirement that a specific user of oracle apex application can be able to reset password of other users when necessary.
  I have written this code for the desired function on button "Change Password" Click event.</p>
  
  <pre><code>BEGIN
   APEX_UTIL.REMOVE_USER(p_user_name =&gt; :P16_USER_ID);
   APEX_UTIL.CREATE_USER(
          p_user_name=&gt; :P16_USER_ID,
          p_web_password=&gt; :P16_USER_ID
        );
   end;
  </code></pre>
  
  <p>But it gives the following message.</p>
  
  <blockquote>
    <p>User requires ADMIN privilege to perform this operation. Contact your
    application administrator.</p>
  </blockquote>