Unlocking User in Oracle Database


STEPS
1. open command prompt
2. login with user: sys
3. use the sql command to unlock the HR,SH user
ALTER USER username ACCOUNT UNLOCK IDENTIFIED BY password;
4. now try to login with user hr & sh in sql developer or sql cmd prompt
Note: i have changed password for user hr from abc123 to hr.

Previous
Next Post »