Change User Password

The user can able to change the password in following way:

#sqlplus username@service_name

SQL> password
Old password:
New password:
Retype new password:
Password changed
SQL>

 

Change Password as Sysdba

SQL> alter user <usernamer> identified by <password>;
User altered.

Comments