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
