15.00 - 15.10 - Creating Databases and Users - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

When Teradata Database is first installed on a server, one user exists on the system, that is, User DBC exists. User DBC owns all other databases and users in the system, and initially owns all the space in the entire system.

When Teradata Database 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 this user and assigns space from User DBC to all other objects (or database and users).

    To protect the security of system tables within Teradata Database, 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 this user 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 Database Administration.