An ODS database password can be changed in one of several ways:

BrioQuery

From the menu, choose Tools and the Connections Manager to bring up the Connections Manager dialog box. In the left-hand side of the dialog box, select Ods.oce from the Document Connections section. Then click the Change Database Password button.

Microsoft Access and Excel

You can also change your password using Microsoft Access or Excel. In each one, you will need to enter the following Oracle SQL syntax to change your password:

alter user your_userid identified by new_password

In Access, you can do this using an SQL Pass-Through Query. To do this, create a New Query. Close the Show Table box without selecting any tables. Then from the menu, choose Query, SQL Specific, Pass-Through. Enter the SQL above and execute the query. The Select Data Source dialog box will appear. Choose your ODS data source and log in using your old password. You will receive the message Pass-through query with Return Records property set to Trude did not return any records. If you do not receive any other message, your password has been changed. (If you receive error messages, try the query again, but add a semi-colon at the end after the new password. Some drivers don't allow the semi-colon; other will take it either way, but there may be some that require the semi-colon.)

In Excel, log into the ODS through Microsoft Query as if you were creating a new database query. When the Add Tables box appears, close it. Click the SQL button on the toolbar. Enter the SQL above and click OK. You will get the message SQL can't be represented graphically. Continue anyway? Click OK. You should receive the message Executed SQL Statement successfully.

If you forget your ODS database password, write to odsadmin@virginia.edu and include a telephone number where you can be reached.

Rules for Passwords

The rules for Oracle database passwords and Oracle application passwords are not quite the same. When choosing a password for your ODS database account, please note the following rules:

• New passwords must be between 6 and 30 characters in length
• Passwords must begin with a letter
• The remaining characters must be numbers or letters
• Passwords are not case-sensitive

Please change your ODS database password on a regular basis. A good practice is to change it when you change your Integrated System application password.