User Implementation Process | Teradata Vantage - 17.10 - User Implementation Process - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)
  1. Satisfy the Prerequisites.
  2. Assign users to functional groups to help assess user setup needs. See Database User Functional Categories.
  3. Use profiles to set user parameters, such as space allocations, password control settings, and security constraint assignments. See Working with Database Profiles.
  4. Review the database user types shown in Database User Types and determine which of them apply to your authentication and authorization strategy. The method for creating users and defining their database privileges varies by user type.
  5. Create the required users:
  6. Review Teradata Vantage User Privileges to understand which privileges you must grant and which are acquired indirectly.
  7. Assign user privileges:
  8. Review additional methods for restricting access based on the structure of the database and its component parts. See Other Options for Restricting Database Access.