Description

This article describes the steps to change/reset your personal Banner or ODS database account password. It also outlines the steps to change your password in other Oracle databases using SQL*Plus and SQL Developer. These steps only apply to personal database accounts and not web or departmental accounts. If you need to change a web or departmental account password, you will need to submit a ticket. Also note that if your database account is locked, you will need to submit a ticket to have it unlocked for you.  

To change your Banner database password:

1. Go to the following URL in a web browser: https://apps.is.colostate.edu/password-change/
2. Login with your NetID credentials.
3. In the “Environment” drop-down box, select either “Production” to change your password in the Banner production (banprod) database, or select “Non-Production” to change your password in ALL Banner test/development databases.
4. Enter your new password, and confirm your new password in the text entry boxes.
5. Click the “Submit” button.

To change your ODS database password:

1. Go to the following URL in a web browser: https://dataaccessreq.is.colostate.edu/account
2. Choose your campus location and login with your NetID credentials.
3. Click on the “MY ACCOUNT” button at the top of the screen.
4. In the “ODS Environment” drop-down box, select either “Production ODS” to change your password in the ODS production (odsprod) database, or select “Non-Production ODS” to change your password in ALL ODS test/development databases.
5. Enter your new password, and confirm your new password in the text entry boxes.
6. Click the “RESET PASSWORD” button.

To change your password manually in any Oracle database:

Instructions for SQL*Plus

1. Open SQL*Plus from your command line or terminal.
2. Connect to the database and account you wish to change. For example:  sqlplus your_username@your_database
   **Replace "your_username" with your actual username and "your_database" with your database service name
3. SQL*Plus will prompt you to enter your current password. Type it in and press Enter.
4. Once logged in, use the following command to change your password:  PASSWORD
5. SQL*Plus will then prompt you to enter your new password twice (once for confirmation).
6. After successfully changing your password, you can exit SQL*Plus by typing:  EXIT

Instructions for Oracle SQL Developer

1. Launch the SQL Developer application from your start menu or desktop shortcut.
2. Right-click on the connection you wish to change.
3. Select the "Reset Password" option from the popup menu.
4. In the subsequent dialog, enter the current password and the new password with confirmation.
5. Click the "OK" button.
6. If you have your connection saved in SQL Developer, you may need to update it with your new password. Right-click your connection, select "Properties", and enter your new password in the Password field. Click "OK" to save the changes.
   

Outcome

Your Oracle database password will be updated. For your convenience, it is recommended to keep your passwords in synch between production and non-production databases.  Otherwise, you'll need to change your non-production database passwords every time a clone occurs.