Reset the DBC Password | Teradata Vantage - 17.00 - 17.05 - Resetting the DBC Password - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Node Software Migration Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Configuration
Installation
Publication ID
B035-5942-170K
Language
English (United States)

After the migration, the DBA must reset the DBC user password from the temporary one that was used for the migration to the permanent password to be used on the new system.

If there is a system password rule that disallows reusing old passwords within a given period of time, the DBA may not be able to reset the DBC password back to the original value it had before the migration. The value in the PasswordReuse column of the Data Dictionary table DBC.SyssecDefaults determines the number of days that must elapse before you can reuse a password. If this value prevents the DBA from setting the password back to the original at the end of the migration, the DBA must either choose a different password or delete the old password from table DBC.OldPasswords, so the DBC password can be reset back to the original value that was in effect before the migration.