17.20 - Default Values for the CREATE PROFILE Statement - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Security Administration - 17.20

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-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572

If you do not specify a value for an optional parameter in the CREATE PROFILE statement, the profile uses the default value.

Many profile parameters also appear in the CREATE USER statement. Settings in a profile always take precedence over settings defined in a CREATE or MODIFY USER statement for the users that are members of the profile. However, if no value appears in the profile, it reverts to the corresponding value in the CREATE USER statement, if specified.

The following table describes the default parameter values the system uses if the profile does not contain a value.

Parameter Result of Not Specifying a Profile Value
ACCOUNT The system uses the default account specified for the user in a CREATE or MODIFY USER statement.

If an account is not specified for the profile or the user, the system uses the account of the owner of the user.

DEFAULT DATABASE The system uses the default database specified for the user in a CREATE or MODIFY USER statement.

If a default database is not specified for the profile or the user, the system uses the username as the default. The user can also specify a default using SET SESSION DATABASE.

SPOOL The system uses the spool limit defined for the user in a CREATE or MODIFY USER statement.

If a spool space limit is not specified for the profile or the user, the system applies the SPOOL value for the immediate owner of the space in which the user is being created.

TEMPORARY The system uses the temp space setting defined for the user in a CREATE or MODIFY USER statement.

If a temp space allocation is not specified for the profile or the user, the user cannot create objects that require temporary space.

PASSWORD The default password control settings are taken from the global defaults for the corresponding attributes in the DBC.SysSecDefaults table. See Viewing Current Password Control Settings.
PASSWORD controls apply only to users authenticated by Teradata Vantage. Externally authenticated users are not affected.