17.10 - Advantages of Using Profiles - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Fundamentals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Simplify system administration.

  • Administrators can create a profile that contains system parameters
  • and assign the profile to a group of users. To change a parameter, the administrator updates the profile instead of each individual user.

Control password security.

A profile can define password attributes such as the number of:

  • Days before a password expires
  • Days before a password can be used again
  • Minutes to lock out a user after a certain number of failed logon attempts

Administrators can assign the profile to an individual user or to a group of users.