Overview of Establishing Users - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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.