Change a user's password in Oracle
Course- Oracle/PLSQL >
Question: How do I change the password for a user in Oracle?
Answer: To change a user's password in Oracle, you need to execute the alter user command.
Syntax
The syntax for changing a password in Oracle is:
ALTER USER user_name IDENTIFIED BY new_password;
Parameters or Arguments
- user_name
- The user whose password you wish to change.
- new_password
- The new password to assign.
Example
Let's look at an example of how to change a password for a user in Oracle/PLSQL.
For example:
ALTER USER smithj IDENTIFIED BY autumn;
This example would change the password for the user named smithj and set the new password to autumn.