using change user password in oracle plsql

Change User Password in SQL – PLSQL

October 31, 2012 by techhoneyadmin

In Oracle SQL / PLSQL a user’s password can be changed using ALTER command.

Syntax for changing the user password using ALTER command in Oracle SQL / PLSQL is:

ALTER USER user_name
IDENTIFIED BY new_password;

Example:

ALTER USER techhoney
IDENTIFIED BY pwdhoney;

Here we have changed the password for “techhoney” user as “pwdhoney”.