Default Values for the CREATE PROFILE Statement - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.