16.10 - CREATE USER Default Values - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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.