16.10 - Using CREATE or MODIFY PROFILE to Set Password Controls for Users - Teradata Database

Teradata Database Security Administration

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

You can use a CREATE or MODIFY PROFILE statement to override global password control parameters defined in SysSecDefaults, and apply a password control only to those users assigned to the profile, for example:

CREATE PROFILE profile_name
           [ AS parameter_setting [ ... ,parameter_setting ] ] ;
           MODIFY PROFILE profile_name AS
                          parameter_setting [ ... ,parameter_setting ];
           The following is the existing PASSWORD parameter_setting:
           PASSWORD [ATTRIBUTES] =
          { (attribute = <val> | NULL, [ ... ,attribute = <val> | NULL]) | NULL }
           where attribute is one of the following in any order:
              EXPIRE = n
              MINCHAR = n
              MAXCHAR = n
              DIGITS = c
              SPECCHAR = c
              RESTRICTWORDS = c
              MAXLOGONATTEMPTS = n
              LOCKEDUSEREXPIRE = n
              REUSE = n