Description This article describes the steps to reset your Banner database account password. This utility only works for personal accounts and does not apply to web or departmental accounts. If you need to change a web or departmental account, you will need to submit a ticket. Also, this service will not unlock your Banner database account in the event it is locked. To have your Banner database account unlocked, you will need to submit a ticket. Instructions Go to the following URL in a web browser: https://apps.is.colostate.edu/password-change/ Login with your NetID credentials. 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. Enter your new password, and confirm your new password in the text entry boxes. Click the “Submit” button. Outcome Your Banner password will be reset in the environment(s) you selected. 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.

Description This article describes the steps to reset your ODS database account password. This utility only works for personal accounts and does not apply to web or departmental accounts. If you need to change a web or departmental account, you will need to submit a ticket. Also, this service will not unlock your ODS database account in the event it is locked. To have your ODS database account unlocked, you will need to submit a ticket. Instructions Go to the following URL in a web browser: https://dataaccessreq.is.colostate.edu/account Choose your campus location and login with your NetID credentials. Click on the “MY ACCOUNT” button at the top of the screen. 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. Enter your new password, and confirm your new password in the text entry boxes. Click the “RESET PASSWORD” button. Outcome Your ODS password will be reset in the environment(s) you selected. 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.

There is an application that users can access to reset their banner Database passwords on their own without the need of a request to a Database Administrator. **Note: This is not the same as resetting your password for the Banner Administration site. This is for database accounts only.** To access this application go to this link: https://apps.is.colostate.edu/password-change and fill out the required fields and which environment you would like to change your password for: production or non-production. Create a new password in accordance with the following rules and click submit. Password Rules: Your password must be 15 to 30 characters long. Your username, first name, or last name must not be part of your password. Certain special characters must not be used: @ $ & " ( ) ' ; = # * < > blank_space You will receive a notification informing you if your password change was successful or not and instructions for who to reach out to if there was an issue.

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: Go to the following URL in a web browser: https://apps.is.colostate.edu/password-change/ Login with your NetID credentials. 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. Enter your new password, and confirm your new password in the text entry boxes. Click the “Submit” button. To change your ODS database password: Go to the following URL in a web browser: https://dataaccessreq.is.colostate.edu/account Choose your campus location and login with your NetID credentials. Click on the “MY ACCOUNT” button at the top of the screen. 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. Enter your new password, and confirm your new password in the text entry boxes. Click the “RESET PASSWORD” button. To change your password manually in any Oracle database: Instructions for SQL*Plus Open SQL*Plus from your command line or terminal. 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 SQL*Plus will prompt you to enter your current password. Type it in and press Enter. Once logged in, use the following command to change your password: PASSWORD SQL*Plus will then prompt you to enter your new password twice (once for confirmation). After successfully changing your password, you can exit SQL*Plus by typing: EXIT Instructions for Oracle SQL Developer Launch the SQL Developer application from your start menu or desktop shortcut. Right-click on the connection you wish to change. Select the "Reset Password" option from the popup menu. In the subsequent dialog, enter the current password and the new password with confirmation. Click the "OK" button. 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.