1 Reply Latest reply: Mar 11, 2014 9:03 AM by fac586 RSS

    how to change the apex username without resetting the password

    Balamurugan Natarajan

      Hi Experts,

       

      I am using APEX 4.2

      I want to change/edit the apex username. I tried to do using APEX_UTIL.EDIT_USER. But the old password doesn't work anymore.

      If i reset the username back to the old one, the password works.

       

      Is there a way i can get this accomplished ?

       

      Thanks,

      Bala

        • 1. Re: how to change the apex username without resetting the password
          fac586

          Balamurugan Natarajan wrote:

           

          I am using APEX 4.2

          I want to change/edit the apex username. I tried to do using APEX_UTIL.EDIT_USER. But the old password doesn't work anymore.

          If i reset the username back to the old one, the password works.

           

          Is there a way i can get this accomplished ?

          No, authentication will be based on matching a stored hash of the username, password and some other salt value. If any of the component values changes then so will their hash result, which will no longer match the stored hash.

           

          You will have to set the username and password simultaneously (even if you don't change the password).