Reset the DBC Password | Teradata Vantage - 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.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
urd1597289951923.ditamap
dita:ditavalPath
urd1597289951923.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
Teradata Vantage

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.