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

SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
zwv1557098532464.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1141
lifecycle
previous
Product Category
Teradata Vantageâ„¢

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.