wikiHow to 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

  1. Image titled Unlock the Account in Oracle Step 1
    1
    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
  2. Image titled Unlock the Account in Oracle Step 2
    2
    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.

Article Info

Categories: Databases