Teradata
don't have a command to lock a specific user account for wrong password
attempts. By default, the DBC.SysSecDefaults table contains the set of global
controls that restrict the usage and content of passwords for all users. However,
we can lock a user in two other ways. [ 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 |