syntax and example of change user password in oracle database query

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:

`1`	`ALTER` `USER` `techhoney`

`2`	`IDENTIFIED` `BY` `pwdhoney;`

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