CREATE USER Default Values - Analytics Database - Teradata Vantage

Security Administration
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-04-05
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantage™

The following table summarizes default values associated with the CREATE USER statement. If you do not define these elements in the CREATE USER statement, the system supplies the default values described in the table.

PERM space and PASSWORD clauses have no default values. You must specify values for both at user creation.
Syntax Element Default Value
FROM database The default database of the creating user.
TEMPORARY If a profile is:
  • Assigned to the user, and includes a TEMPORARY value, the default is the value defined in the profile.
  • Assigned but does not include a TEMPORARY value, the default is the same TEMPORARY value as the immediate owner of the space in which the user is created.
  • Not assigned, the default is the same TEMPORARY value as the immediate owner of the space in which the user is created.
SPOOL If the profile is:
  • Assigned to the user, and includes a SPOOL value, the default is the value defined in the profile.
  • Assigned but does not include a SPOOL value, the default is the SPOOL value for the immediate owner of the space in which the user is created.
  • Not assigned, the default is the SPOOL value for the immediate owner of the space in which the user is created.
DEFAULT DATABASE The user name.

The user can submit a SET SESSION DATABASE statement to change the default for the current session, as long as the appropriate privileges on that database are granted to the user.
ACCOUNT If a profile is:
  • Assigned to the user, but the profile contains more than one account, the default is the first account in the string. The user can submit a SET SESSION ACCOUNT statement to set the default for the current session to one of the other accounts.
  • Assigned to a user and the profile contains only one account, the default is the account defined in the profile.
  • Assigned to a user, but the profile does not include an account, the default is the account identifier of the immediate owner of the user.
  • Not assigned to the user, the default is the account identifier of the immediate owner of the user.
If a user definition specifies an account but not a profile, the default account is the account string in the user definition.

If you assign a profile to a user, and the profile specifies an account string, the profile account is in effect for AMPUsage and DBQL for that user. However, the system uses the value found in the DBC.DatabaseV view for space accounting.
DEFAULT ROLE Null.

The database does not use a role for privilege validation unless the user submits a SET ROLE statement for roles that you explicitly grant to the user, including nested roles.

See Assigning the Default Role.
STARTUP Null (no startup string).
PROFILE Null. No profile exists for the user.