Monday, February 16, 2015

Unlock user command for Oracle Database

Sometime a user gets locked and can not log in to database. To unlock it we need to run following command.

SQL> alter user username identified by Password account unlock;
User altered.
SQL>

0 comments:

Post a Comment