SQL Developer How Change Password? – 2 Cool And Simple Methods?

You are currently viewing SQL Developer How Change Password? – 2 Cool And Simple Methods?
Share This Post, Help Others, And Earn My Heartfelt Appreciation! :)
4.9
(894)

In this short tutorial I will bring you closer to the topic: SQL Developer How Change Password / Reset Password? We can change the password in at least two ways, using:

SQL Developer How change password in Oracle Database?

Changing the password may be forced by security reasons, that you need to set a more suitable password, or you simply are approaching the expiration date of the password and we want to change it before the deadline. Or even you forgot Oracle database password.

In this tutorial I will show you 2 approaches how you can change the password.

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

Method 1 -> SQL Statement

In first method you can use any Database Editor you like. It can be DBeaver, Toad or SQL Developer from Oracle.

Using SQL syntax. Use below SQL statement, change to your values and execute.

alter user user_name identified by you_new_password replace old_password;

Method 2 -> Using SQL Developer Tool

Using Oracle tool. 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“.

SQL Developer How change password? - 2 cool and simple methods?
Changing password with Oracle SQL Developer

Summary

I hope that thanks to this short post you were able to change your password and everything works as it should 🙂 Let me know if you liked this post.

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

How useful was this post?

Click on a star to rate it!

Average rating 4.9 / 5. Vote count: 894

No votes so far! Be the first to rate this post.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments