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

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
Configuration
Installation
featnum
B035-5942-170K

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.