Unlock Accounts in Oracle 10g

You can lock/unlock the account by the following method.

To Lock:
ALTER USER username ACCOUNT LOCK;
Example:
Alter user john account lock;


To Unlock:
ALTER USER username ACCOUNT UNLOCK;
Example:
Alter user john account unlock;

No comments:

Post a Comment