Create User Accounts | Teradata Vantage - Creating User Accounts - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

Each user logon to the database should specify an account string.

Accounts are used by the database to:

  • Prioritize requests. This classification is in effect only when TASM or TIWM classification processes cannot match a request to a user-defined workload.
  • Monitor resource usage
  • Charge for space or resources used

Teradata recommends that you specify at least one account for each user. Users with similar responsibilities and resource requirements should be assigned to the same account(s) to reduce the overall number of accounts you must maintain.

You can specify accounts in the following:

  • A CREATE PROFILE or MODIFY PROFILE statement for the profile specified in the user definition (preferred).
  • A CREATE USER or MODIFY USER statement.
    If a user is a member of a profile that specifies one or more accounts, the profile account assignments supersede and invalidate any accounts specified in the user definition.