How to unlock HR sample account in oracle 11G express edition

How to Unlock HR sample account in oracle 11G express edition

This session will cover how to unlock HR sample account in oracle 11G express edition.
Here is the steps to follow …

1. Go to CMD (Command Prompt)

2. Execute below commands in CMD

3. To connect to oracle database 11 G
SQLPLUS / AS SYSDBA;

4. To alter HR user to unlock
ALTER USER HR ACCOUNT UNLOCK;

5. To Unlock the user and assign a password for the user HR.
ALTER USER HR IDENTIFIED BY <password>;

6. To lock the user again
ALTER USER HR ACCOUNT LOCK;

Watch the video on YouTube 

If you have any further question or need any clarification on this session please do send an e-mail to kvtinformatica@gmail.com

 

Leave a comment

Your email address will not be published. Required fields are marked *