Create user in Teradata

Like you know, when you want to connect to any application you need user Id and password. A Teradata user is a database with an assigned password which is use to connect to the Teradata database.

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:-

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

When you create a user in Teradata you should initial a command with the CREATE USER.

Below is the Example:-

CREATE USER Test_User FROM DBC AS
PERMANENT = 100000000,
SPOOL = 100000000,
TEMPORARY =  100000000,
PASSWORD = p@w0rd ;

“Test_User” is owned by “DBC”.

After creating a user you need to grant the required privileges to the user so it can access database objects.

For granting the privileges you need to initiate command with GRANT.

GRANT SELECT on Tera_Test TO Test_User;