Establish Users | Teradata Vantage - 17.00 - 17.05 - Overview of Establishing Users - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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

  1. Group potential database users by functional group and determine database access needs. See Assessing Database User Needs.
  2. Set up accounts to track resource usage and assign workload priorities. See Creating User Accounts.
  3. Set up profiles to define resources, account assignments, and password control parameters for groups of users. See Creating User Profiles.
  4. Create database users and assign profiles, space and accounts. See Working with Database Users.
  5. Create roles to define privileges for users groups and grant role membership to users. See Using Roles to Manage User Privileges.
  6. Grant additional privileges that are not suitable for role assignment directly to users. See Granting Privileges Directly To Users.