Overview of Establishing Users - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

To establish users for the first time, perform all the tasks in this chapter completely and in the order presented.

1 Group potential database users by functional group and determine database access needs. See “Assessing Database User Needs” on page 104.

2 Set up user accounts to track resource usage and assign workload priorities. See “Creating User Accounts” on page 106.

3 Set up profiles to define resources, account assignments, and password control parameters for groups of users. “Creating User Profiles” on page 108.

4 Create database users and assign profiles, space and accounts. See “Working with Database Users” on page 111.

5 Create roles to define privileges for users groups and grant role membership to users. “Using Roles to Manage User Privileges” on page 115.

6 Grant additional privileges that are not suitable for role assignment directly to users. See “Granting Privileges Directly to Users” on page 123.