Wednesday, August 31, 2016

How to unlock DB account?

ALTER USER <user> IDENTIFIED BY <password> ACCOUNT UNLOCK;

For Example:
Most of the cases Oracle HR user - by default it will be locked. To unlock that account use following query:

ALTER USER HR IDENTIFIED BY HR ACCOUNT UNLOCK;

No comments:

Post a Comment