Oracle PL/SQL Tutorial/User Privilege/Password

Change the password for the current user using the PASSWORD command

SQL>
SQL>
SQL> PASSWORD
Changing password for SYS
Old password:
New password:
Retype new password:
Password unchanged
SQL>

Changing a User"s Password Using the ALTER USER statement

SQL>
SQL> --CONNECT system/manager
SQL> CREATE USER user1 IDENTIFIED BY pass1;
User created.
SQL>
SQL> GRANT CREATE SESSION TO user1;
Grant succeeded.
SQL>
SQL> ALTER USER user1 IDENTIFIED BY pass2;
User altered.
SQL>
SQL> DROP USER user1;
User dropped.