Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Change User Password in Oracle?

If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example:

>.insqlplus /nolog

SQL> connect SYSTEM/globalguideline

Connected.

SQL> ALTER USER DEV IDENTIFIED BY beginner;

User altered.

Note that ALTER is SQL statement, so you need to terminate it with ";". This command resets DEV's password to "beginner".

 134 views

More Questions for you: