Changing the Database Password - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Changing the Database Password

Use the following procedure to change the password in the database for Teradata, Oracle, MySQL and SQL Server databases. It might not be possible to change the password on all database systems, like Microsoft Access. Changing the password in the Database does not change a password that is stored in the ODBC data source definition. Storing a password in the ODBC data source is not secure and is not recommended.

1 Select Tools > Change Password.

2 In the Change Database Password dialog box, enter the current password.

3 Enter the new password.

Note: Do not use the semicolon (;) or the equal sign (=) when changing database passwords if any ODBC or .NET-based applications are being used.

4 Re-enter the new password to confirm it.­