SecurityDefaultsV - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.