PCAS_CredentialComplexity (ver7.0.0)
Used for defining credential complexity requirements for a service.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ExpirationWarningDays | 7.0.0 | Number(10) | The number of days prior to password expiration that a warning is provided to the user. Valid values: 0 = Disabled, Positive Integer = Enabled. Defaults to 3. Required. |
HardLockOutThreshold | 7.0.0 | Number(10) | The number of failed login attempts by a username, service, and IP which would cause a hard lock out, requiring an admin to reset the password, if a hard lock out is enabled. Required. |
IsHardLockOutEnabled | 7.0.0 | Number(1) | Indicates to lock a user's account on a given number of failed login attempts. Valid values: 0 = False (disabled), 1 = True (enabled). Defaults to 0. Required. |
IsLettersAndNumReq | 7.0.0 | Number(1) | Indicates at least one letter and one number are required for a password. Valid values: 0 = Disabled, 1 = Enabled. Defaults to 0. Required. |
IsMixOfCaseReq | 7.0.0 | Number(1) | Indicates at least one upper and one lowercase character are required for a password. Valid values: 0 = Disabled, 1 = Enabled. Defaults to 0. Required. |
IsResetRuleEnabled | 7.0.0 | Number(1) | Indicates a user is required to reset their password upon first logging in. Valid values: 0 = Disabled, 1 = Enabled. Password Reset Rule is enabled. Defaults to 1. Required. |
IsSpecialCharacterReq | 7.0.0 | Number(1) | Indicates at least one special character is required for a password. Valid values: 0 = Disabled, 1 = Enabled. Defaults to 0. Required. |
PasswordExpireDays | 7.0.0 | Number(10) | Indicates the number of days a user may use a password before being required to enter a new password. Valid values: 0 = Disabled, Positive Integer = Enabled. Defaults to 60. Required. |
PasswordReuseCycleNum | 7.0.0 | Number(1) | The number of different password that must be used before a password may be reused when the password is reset. Valid values: 0 = Disabled, Positive Integer = Enabled. Defaults to 5. Required. |
PCAS_CredentialComplexityID | 7.0.0 | Number(19) | Unique identifier for this table. Required. |
PCAS_ServiceID | 7.0.0 | Number(19) | Indicates the service for which the credential complexity rules apply to, such as administrators, administrative assistants, students, substitutes, system administrators, or teachers. Required. |
ReqCharacterCnt | 7.0.0 | Number(10) | Indicates the minimum number of alpha/numeric characters that must be used in a password. Valid values: 0 = Disabled, Positive Integer = Required password length. Defaults to 7. Required. |
WhenCreated | 7.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 7.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 7.0.0 | Varchar2(100) | The name of the person who create the record. Defaults to user. |
WhoModified | 7.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |