MODIFY USER, Journal Tables, and Default Map - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Modifying the default map of the user does not change the map being used for the journal table.

If the MODIFY USER statement specifies a journal table and a default map, the journal table is created using this default map. The journal table map must be a contiguous map with the same AMPs as TD_GlobalMap.

If the MODIFY USER statement specifies a journal table without specifying a default map, the system determines the map for the journal table in the following order of precedence:
  • Default map, if defined, for the profile of the database creator. See the DEFAULT MAP option of CREATE PROFILE.
  • Default map, if defined, for the database creator. See the DEFAULT MAP option of CREATE USER.
  • System-default map.