Unlock the Account in Oracle
A user account can be locked by an expiration of a password and can be unlocked with a command.
Steps
- Find which accounts are locked with the following query.
- SQL > select username,account_status from dba_users where account_status like '%LOCK%';
- USERNAME ACCOUNT_STATUS
- ------------------------------ ----------------
- OUTLN EXPIRED & LOCKED
- MDSYS EXPIRED & LOCKED
- MDDATA EXPIRED & LOCKED
- Unlock the user with the following command.
- SQL > alter user MDDATA account unlock; User altered.
Tips
- You can also lock an account with the following:
- SQL > alter user MDDATA account lock;
- User altered.
