About Profiles | Teradata Vantage - About Profiles - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
upb1600054424724.ditamap
dita:ditavalPath
upb1600054424724.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantageā„¢

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, or other factors that group users according to database resource requirements.

Use profiles to specify parameters such as:

  • Temporary and spool space allocations
  • Accounts
  • Password control parameters
  • Default database assignment
  • Query band
The value for a profile attribute supersedes and replaces any corresponding values specified in global defaults, or in a CREATE USER request.