15.00 - 15.10 - Example: Creating a Finance and Administration Database - 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

Consider the following example: the database administrator needs to create a Finance and Administration (F&A) department database with User Jones as a supervisory user, that is, as database administrator within the F&A department.

The database administrator first creates F&A Database and then allocates space from it to User Jones to act as the F&A database administrator. The database administrator also allocates space from F&A to Jones for his personal use and for creating a Personnel Database, as well as other databases and other user space allocations. The following figure illustrates the hierarchy implicit in this relationship.

F&A Database owns Personnel Database and all the other department databases.

F&A Database also owns User Jones and all other users within the department.

Because User DBC ultimately owns all databases and users, it is the final owner of all the databases and user space belonging to the organization.

This hierarchical ownership structure provides an owner of a database or user space with complete control over the security of owned data. An owner can archive the database or control access to it by granting or revoking privileges on it.

Note: There can only one immediate owner of a database or user.

For more information on the topics presented in this chapter, see the following Teradata Database books.

 

If you want to learn more about…

See…

Tables

  • SQL Data Definition Language
  • SQL Data Manipulation Language
  • Queue tables

  • SQL Data Definition Language
  • SQL Data Manipulation Language
  • Views

    SQL Data Definition Language

    SQL stored procedures

  • SQL Data Definition Language
  • SQL Stored Procedures and Embedded SQL
  • SQL external stored procedures

  • SQL Data Definition Language
  • SQL Stored Procedures and Embedded SQL
  • Macros

    SQL Data Definition Language

    Triggers

    SQL Data Definition Language

    User-Defined Functions

  • SQL Data Definition Language
  • SQL External Routine Programming
  • User-Defined Methods

  • SQL Data Definition Language
  • SQL External Routine Programming
  • User-Defined Types

  • SQL Data Definition Language
  • SQL External Routine Programming
  • Databases and Users

    Database Administration