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. |