16.10 - Best Practices for Database Creation - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)

To ensure data integrity, Teradata recommends that only administrators and high-level users have the privilege to access data tables. All other database activity should be done in views.

Teradata recommends that you create top-level databases to separate tables and views. You can create additional lower-level databases within the top level databases as required by site security policy and user access needs.

Database Description
  • Owns perm space.
  • Contains all tables and data.
  • Normally accessible only to privileged administrative and batch users for creating and modifying database objects or performing data loads and updates.
  • Requires minimal perm space because it does not contain data.
  • Contains views of the tables in the Tables_Database.
  • Exists primarily to provide SELECT access to the data for all users.
Where security policy requires it, you can designate a layer of views for load and update operations so that even batch users do not need to directly access data tables.