Lesson 40 - How to change password

Change existing  schema/user  password
Syntax :

ALTER USER <username>  IDENTIFIED BY  new_ password

Note : You must have the ALTER USER system privilege. However, you can change your own password without this privilege.

Example :

SQL> ALTER USER  appuser IDENTIFIED BY  bluerose;

User altered