15.00 - Profiles - Teradata Database

Teradata Database SQL Fundamentals

Teradata Database
Programming Reference


Profiles define values for the following system parameters:

  • Default database
  • Spool space
  • Temporary space
  • Default account and alternate accounts
  • Password security attributes
  • Optimizer cost profile
  • An administrator can define a profile and assign it to a group of users who share the same settings. For information on Optimizer cost profiles, see SQL Request and Transaction Processing

    Advantages of Using Profiles

  • 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.


    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
  • 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.

    Related Topics


    For information on …

    See …

    the syntax and usage of profiles

    SQL Data Definition Language.

    passwords and security

    Security Administration.

    optimizer cost profiles

    SQL Request and Transaction Processing.