Change password Oracle

How to change password in Oracle

Data is the back bone of any Organization, so we must protect it from un-authorize access. First step is protect the Oracle Account is enforce strong password which people cannot guess or brute force. If you think that Oracle account password is weak, you can use any of the below method to change it

1. Using SQL Plus

Step 1. Connect to SQL Plus
Step 2. Issue below command
SQL> password
Changing password for MANOJ
Old password:
New password:
Retype new password:
Password changed
SQL>

Please make sure that password policies are met. In general password must contain a capital letter,one symbol and one numeric.

2. Using TOAD

a) Using GUI

Step1. Connect to TOAD
Step2. Open Session –> Change Password

change password TOAD
change password TOAD

Step3. Enter old and new password and click “Execute”

change password TOAD window
change password TOAD window

b) Using Command
Step1. Connect to TOAD
Step2. Open SQL Editor
Step3. type keyword “password” and run. It will popup a password change window

3. Using SQL Developer

Step1. Connect to SQL eveloper
Step2. Open SQL Editor
Step3. type keyword “password” and run. It will popup a password change window

change password SQL Developer
change password SQL Developer

4. Get help from DBA

DBAs also can change/reset password for you.

Advertisements

Author: sqlandplsql

To learn more about the Oracle, SQL, PL SQL, Performance Tuning, Database Modeling, Ubuntu, MySQL etc .Suggestions, comments, feedbacks and referrals are highly appreciated.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s