Change User Password in SQL – PLSQL

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”.


Tagged , , , , , , , , , , , . Bookmark the permalink.