Change user's password in Oracle

To Change the password of a user in Oracle

You need to execute the alter user command

Syntax:

 SQL>alter user user_name identified by password;

                                   (or)

you just type as 

SQL>password

This will promt you to enter your old password and thereafter your new password.

Posted by: Anil Bandi

Oracle DBA