Creating Databases and Users - Analytics Database - Teradata Vantage

Database Introduction

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-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢
When Vantage is first installed on a server, user DBC is created. User DBC owns (with some exceptions):
  • All free space on the system
  • All databases and users created after installation

The database administrator manages user DBC and assigns space from user DBC to all other objects (or database and users).

To protect the security of system tables within Vantage, the database administrator typically creates user System Administrator from user DBC. The usual procedure is to assign all database disk space that system tables do not require to user System Administrator.

The database administrator then uses user System Administrator as a resource from which to allocate space to other databases and users of the system.

For information on how to create databases and users, see Teradata Vantageā„¢ - Database Administration, B035-1093.