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;
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