Resetting the DBC Password - Teradata Database

Teradata Database Node Software Migration Guide

Product
Teradata Database
Release Number
15.10
Published
November 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
heq1467819788761.ditamap
dita:ditavalPath
5942_Migrating_1510.ditaval.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software

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.