2 Replies Latest reply: Feb 7, 2012 11:50 PM by HamidHelal RSS

    how to unlock user

    914284
      I installed Oracle 11g R2 sucessfully. But not able to login as i found message user locked , kindly guide me how to unlock user.
        • 1. Re: how to unlock user
          910820
          Pobaly your user needs create session priviledge.

          Log in as a SYSTEM and performs the grant below.

          grant create session to USER;

          Regards,

          Raul.
          • 2. Re: how to unlock user
            HamidHelal
            911281 wrote:
            I installed Oracle 11g R2 sucessfully. But not able to login as i found message user locked , kindly guide me how to unlock user.
            To unlock a user Run the following sql as administrator user like SYS or SYSTEM
            ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;
            here password is your passord which you want to use for your account remember this password for further use.


            Hope this will help you




            If someone's response is helpful or correct, please mark it accordingly.