17.00 - SecurityDefaultsV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Security

Database: DBC

View Column Data Type Format Comment
ExpirePassword SMALLINT NOT NULL ---,--9 Returns the number of days to elapse before the password expires. 0 indicates the password does not expire.
PasswordMinChar BYTEINT NOT NULL -(3)9 Returns the minimum number of characters in a valid password string.
PasswordMaxChar BYTEINT NOT NULL ---9 Returns 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) To define 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) Returns 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 Returns the 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 Returns the number of days to elapse before a password can be reused. 0 indicates immediate reuse.