Fixing User DBC Default Roles - Teradata Database

Teradata Database Node Software Migration Guide

Product
Teradata Database
Release Number
16.10
Published
November 30, 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
bkn1504122461303.ditamap
dita:ditavalPath
5942_Migrating_1610.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
If default roles are assigned to User DBC, the roles are automatically changed to NULL during the upgrade. The report file dbc_roles.rpt lists those roles.
DBC must have full access rights for DBC prior to archiving/restoring DBC. If DBC does not have full access rights for DBC, then those right need to be granted prior to performing the archive. If the source system is not available, then once DBC has been restored, full access rights have to be explicitly granted for each object, view, and macro under DBC before the post_dbc_restore script and DIP will run successfully.