Administrative Infrastructure System-Generated Users | Teradata Vantage - About System-Generated Users - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢
The database automatically creates system-level database users during initial system setup:
  • User DBC (the master administrative user) performs the initial steps for database setup and maintains the data dictionary tables.
  • PUBLIC, the default user identity, has a set of privileges that are available to all users, primarily the SELECT privilege on most Data Dictionary views.
  • Other system-generated users, such as SystemFE, perform automated system-level tasks in the database. You can optionally configure system users to perform additional tasks.

Depending on the release, installing or upgrading may automatically create a new user group and user that is granted access permissions to run certain OS-level processes required by Teradata Vantage. You may need to manually grant additional OS permissions to the user and to other administrative users. Also see Working with OS-Level Security Options.