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 »

ConversionConversion EmoticonEmoticon

:)
:(
=(
^_^
:D
=D
=)D
|o|
@@,
;)
:-bd
:-d
:p
:ng
:lv