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

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)
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.