SecurityDefaultsV - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

Category: Security

Database: DBC

View Column Data Type Format Description
ExpirePassword SMALLINT NOT NULL ---,--9 The number of days to elapse before the password expires. 0 indicates the password does not expire.
PasswordMinChar BYTEINT NOT NULL -(3)9 The minimum number of characters in a valid password string.
PasswordMaxChar BYTEINT NOT NULL ---9 The maximum number of characters in a valid password string. PasswordMaxChar must be equal to or greater than PasswordMinChar.
PasswordDigits CHAR(1) LATIN UPPERCASE NOT NULL X(1) Indicates whether digits are allowed in a password string. A value of Y indicates yes while N indicates no. The default is Y.
PasswordSpecChar CHAR(1) LATIN UPPERCASE NOT NULL X(1) A code to indicate which special characters are to be allowed in the password. For the definition of the codes, see DBC.SysSecDefaults.
PasswordRestrictWords CHAR(1) LATIN UPPERCASE NOT NULL X(1) Indicates whether to restrict certain words from being contained within a password string. These are the valid values: Y (Yes), N (No). The default is N.
MaxLogonAttempts BYTEINT NOT NULL -(3)9 Number of erroneous logons before the user is locked. 0 (user never locked).
LockedUserExpire SMALLINT NOT NULL ---,--9 Number of minutes to elapse before a locked user is unlocked. 0 indicates immediate unlock. -1 indicates user is locked indefinitely.
PasswordReuse SMALLINT NOT NULL ---,--9 Number of days to elapse before a password can be reused. 0 indicates immediate reuse.