Creating Databases and Users - Advanced SQL Engine - Teradata Database

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.

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 Teradata Vantage™ - Database Administration, B035-1093.