Teradata Database & User

Hi,

Here we will learn what is teradata Database & Teradata user.

Teradata Database:

• A Teradata database is a defined logical repository for:

                   ---> Tables

                   ---> Views

                   ---> Macros

                   ---> Triggers

                   ---> Stored Procedures

• Attributes that may be specified for a database:

                  ---> Perm Space - maximum amount of space available for tables

                  ---> Spool Space - maximum amount of work space available for requests

                  ---> Temp Space - maximum amount of temporary table space

• A Teradata database is created with the CREATE DATABASE command.

Example:

 

CREATE DATABASE Database_2 FROM Sysdba   

 AS PERMANENT = 20e9, SPOOL = 200e6;

“Database_2” is owned by “Sysdba”. A database is empty until objects are created within it.

Teradata User: 

• A Teradata user is a database with an assigned password.
• A Teradata user may logon to Teradata and access objects within:

                      ---> itself
                      ---> other databases for which it has access rights

• Examples of attributes that may be specified for a user:

• A user is an active repository while a database is a passive repository.
• A user is created with the CREATE USER command.

Example:

CREATE USER User_C FROM User_A
AS  PERMANENT = 10e6
  ,SPOOL = 100e6
  ,TEMPORARY =  80e6
  ,PASSWORD = lucky_day ;

“User_C” is owned by “User_A”. A user is empty until objects are created within it.

                      ---> Perm Space - maximum amount of space available for tables
                      ---> Spool Space - maximum amount of work space available for requests
                      ---> Temp Space - maximum amount of temporary table space