15.00 - Profiles - Teradata Database

Profiles

Profiles define values for the following system parameters:

Default database

Spool space

Temporary space

Default account and alternate accounts

Password security attributes

Optimizer cost profile

An administrator can define a profile and assign it to a group of users who share the same settings. For information on Optimizer cost profiles, see SQL Request and Transaction Processing

Advantages of Using Profiles

Simplify system administration.

Administrators can create a profile that contains system parameters and assign the profile to a group of users. To change a parameter, the administrator updates the profile instead of each individual user.

Control password security.

A profile can define password attributes such as the number of:

Days before a password expires

Days before a password can be used again

Minutes to lock out a user after a certain number of failed logon attempts

Administrators can assign the profile to an individual user or to a group of users.

Usage

The following steps describe how to use profiles to manage a common set of parameters for a group of users.

1 Define a user profile.

A CREATE PROFILE statement defines a profile, and lets you set:

Account identifiers to charge for the space used and a default account identifier

Default database

Space to allocate for spool files and temporary tables

Optimizer cost profile to activate at the session and request scope level

Number of incorrect logon attempts to allow before locking a user and the number of minutes before unlocking a locked user

Number of days before a password expires and the number of days before a password can be used again

Minimum and maximum number of characters in a password string

The characters allowed in a password string, including whether to:

Allow digits and special characters

Require at least one numeric character

Require at least one alpha character

Require at least one special character

Restrict the password string from containing the user name

Require a mixture of uppercase and lowercase characters

Restrict certain words from being a significant part of a password string

2 Assign the profile to users.

Use the CREATE USER or MODIFY USER statement to assign a profile to a user. Profile settings override the values set for the user.

3 If necessary, change any of the system parameters for a profile.

Use the MODIFY PROFILE statement to change a profile.

Related Topics

For information on …	See …
the syntax and usage of profiles	SQL Data Definition Language.
passwords and security	Security Administration.
optimizer cost profiles	SQL Request and Transaction Processing.