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.
|