How to change Password, LOCK and UNLOCK the user accounts.

Change the password of a user.

1.       Login as DBA / User.

2.      Syntax:

ALTER USER <username> IDENTIFIED BY <new_password>

3.       Ex:

ALTER USER JOHN IDENTIFIED BY ORACLE

Lock/ Unlock USER account.

1.       Login as DBA.

2.      Syntax:

ALTER USER <username> ACCOUNT <lock/ unlock>

3.       Ex:

a)      ALTER USER JOHN ACCOUNT LOCK;

b)     ALTER USER JOHN ACCOUNT UNLOCK;