Unlock the Account in Oracle
Revision as of 04:55, 26 April 2022 by Kipkis (Kipkis | contribs) (Text replacement - "[[Category:D" to "[[Category: D")
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.