SQL> ALTER USER user_name IDENTIFIED BY user_password ACCOUNT UNLOCK;
Now you can log in to the database using the user_name user with the password user_password. Remember, the password is case sensitive.
Example:
22 авг. 2014 г.
on
How to unlock Oracle database user
To unlock oracle database user just run this query:
SQL> ALTER USER user_name IDENTIFIED BY user_password ACCOUNT UNLOCK;
Now you can log in to the database using the user_name user with the password user_password. Remember, the password is case sensitive.
Example:
SQL> ALTER USER user_name IDENTIFIED BY user_password ACCOUNT UNLOCK;
Now you can log in to the database using the user_name user with the password user_password. Remember, the password is case sensitive.
Example:
