Oracle database: How can I change a user's password using Oracle SQL Developer?

We can change the password in at least two ways, using:

  1. SQL syntax
  2. Using Oracle SQL Developer software.

Method 1

alter user user_name identified by you_new_password replace old_password;

Method 2

Using SQL Developer. Click the right mouse button on the connection to which you want to change the password, then select “Reset password…”. In the new window, first enter the current password, then enter the new password twice and click “OK“.

If you enjoyed this post please add the comment below or share this post on your Facebook, Twitter, LinkedIn or another social media webpage.
Thanks in advanced!

0 0 vote
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments