SQL> select username,ACCOUNT_STATUS from dba_users where USERNAME='ABCD'; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- ABCD EXPIRED & LOCKED
To resolve i gave following command
1. Check the current password :
SQL> select username,password from dba_users where username='ABCD';
USERNAME PASSWORD
------------------------------ ------------------------------
ABCD 8B0354E43FEE9F31
2. alter user abcd account unlock;
3. alter user identified by user abcd ;
4. Reverted the password :
SQL> alter user ABCD identified by values '8B0354E43FEE9F31';
SQL> select username,ACCOUNT_STATUS from dba_users where USERNAME='ABCD'; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- ABCD OPEN
No comments:
Post a Comment