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 firstname.lastname@example.org