Other System Database and Users | Teradata Vantage - Other System Databases and Users - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

The following table lists some of the additional users and databases created during the installation process.

System Database/User Description
CRASHDUMPS CRASHDUMPS is defined in the Data Dictionary when the DIPCRASH script is run during the DIP phase of installation, migration, or upgrade. This user is created for use by the system for logging internal errors. Adjust the space allocation accordingly and monitor its usage. CRASHDUMPS provides temporary storage of dumps generated by the Parallel Database Extensions (PDE) software. You may need to allocate more PERM space, based on the size of your configuration, to accommodate at least three dumps.
Sys_Calendar
Sys_Calendar is defined in the Data Dictionary when the DIPCAL script is run during the DIP phase of installation, migration, or upgrade. This database contains tables and views related to the system calendar, including the Calendar view, which is a user-accessible tool for date arithmetic. For more information, see “CALENDAR System View” in Teradata Vantage™ - Data Dictionary, B035-1092.
TD_SYSFNLIB
The TD_SYSFNLIB system database is created when the DIPDB or DIPALL scripts are run during the DIP phase of installation, migration, or upgrade. This database contains the non-type-specific embedded services functions offered as part of the database release. For details on embedded services functions, see Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145.
Do not create any database objects in the TD_SYSFNLIB database. The TD_SYSFNLIB database is for internal use only.
ALL, DEFAULT, and PUBLIC may appear as databases or user names but actually have no content, no tables, no views, and users cannot log on to them. They are defined with no PERM space and are used by the database system software. For more information, see “Special Keywords” in Teradata Vantage™ - Data Dictionary, B035-1092.

User DBC not only owns all these system databases/users but also has access to everything in the system because it has privileges on everything as well. Therefore, rather than use DBC to manage the system and risk accidentally changing the system users, create an administrative user to manage the system.