17.10 - Usage - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1141-171K
Language
English (United States)

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
      Optimizer cost profiles are not intended for use on production systems. The Cost Profile parameter is for use only under the direction of Teradata Support Center personnel.
    • 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.