16.10 - Usage - Teradata Database

Teradata Database SQL Fundamentals

Teradata Database
Release Number
June 2017
English (United States)
Last Update

The following steps describe how to use profiles to manage a common set of parameters for a group of users.

  1. Define a user profile.

    A CREATE PROFILE statement defines a profile, and lets you set:

    • Account identifiers to charge for the space used and a default account identifier
    • Default database
    • Space to allocate for spool files and temporary tables
    • Optimizer cost profile to activate at the session and request scope level
    • Number of incorrect logon attempts to allow before locking a user and the number of minutes before unlocking a locked user
    • A query band to enforce query band name/value pairs
    • Number of days before a password expires and the number of days before a password can be used again
    • Minimum and maximum number of characters in a password string
    • The characters allowed in a password string, including whether to:
      • Allow digits and special characters
      • Require at least one numeric character
      • Require at least one alpha character
      • Require at least one special character
      • Restrict the password string from containing the user name
      • Require a mixture of uppercase and lowercase characters
      • Restrict certain words from being a significant part of a password string
  2. Assign the profile to users.

    Use the CREATE USER or MODIFY USER statement to assign a profile to a user. Profile settings override the values set for the user.

  3. If necessary, change any of the system parameters for a profile.

    Use the MODIFY PROFILE statement to change a profile.