How to change Oracle passwords for user accounts

Use the instructions below to change your Oracle password for user accounts in SIS.

Oracle passwords must be at least 12 characters in length and contain one or more of each of the following:
  • Upper case letter A-Z
  • Lower case letter a-z
  • Numeric digit 0-9
  • Special character !@#$%^&*()_+
Depending upon the tools you use to access Oracle, you may need to avoid using some characters (for example double-quote)

How to change your password in TOAD

Open Toad, open a session in the environment where you wish to change your password, then use the Session drop-down menu 
to select 'Change Password'.


After clicking on 'Change Password' you will be presented with a screen like this; 

Toad password change window

enter the new password in both fields and click OK.

How to change a password in Oracle SQL Developer

Open SQL Developer, right click on an open connection. On the drop down menu, select 'Reset password.'


After clicking on 'Reset Password' you will be presented with a screen like this; 



enter the new password in both fields and click OK.

How to change a password in any SQL Tool

You can use a direct SQL statement to update your password in any tool. The syntax is:

ALTER USER user_name IDENTIFIED BY “new_password” REPLACE “old_password”;

In this statement, replace user_name with the 3-character personal ID or the system account user name and replace new_password and old_password with your current and new password. Use the quotation marks to ensure that special characters will be interpreted correctly as part of the password.




Keywords:oracle, password, sql,   Doc ID:78730
Owner:John N.Group:ERP Security
Created:2017-12-13 14:44 CDTUpdated:2018-08-01 09:07 CDT
Sites:ERP Security
Feedback:  2   1