Databases and Users | SQL Fundamentals | Teradata Vantage - 17.10 - Databases and Users - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1141-171K
Language
English (United States)

A database is a container with an allotment of space in which users can create and maintain database objects, including tables, views, triggers, indexes, stored procedures, user-defined functions, and macros.

A user is similar to a database, except that a user has a password and can log on to the system, whereas a database cannot.

The primary database user is DBC, which owns all system disk space and contains the Data Dictionary tables and other system objects and information.