Creating User Profiles - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

About Profiles

You can create profiles to define resource parameters for groups of users with similar needs instead of defining them for each individual user. Then list the profile in a CREATE or MODIFY USER statement to establish membership in a profile for each user.

Profiles can be based on the primary user types such as those shown in “Types of Users” on page 104, or other factors that group users according to database resource requirements.

Use profiles to specify parameters such as:

  • Permanent and spool space allocations
  • User account(s)
  • Password control parameters
  • Default database assignment
  • Query band
  • Note: The value for a profile attribute supersedes and replaces any corresponding values specified in global defaults, or in a CREATE USER request.