Field |
Type |
Defaults |
Nulls? |
Comments |
accountLockoutEnabled |
tinyint |
None |
No |
Whether the account lockout policy is enabled. |
attemptExpirationTimeNumber |
int |
None |
Yes |
The numerical component of the period at which attempts will expire. |
attemptExpirationTimeUnit |
nvarchar (255) |
None |
Yes |
The time unit component of the period at which attempts will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS. |
attemptsAllowed |
int |
None |
No |
The number of failed login attempts allowed before account lockout. |
lockoutExpirationTimeNumber |
int |
None |
Yes |
The numerical component of the period at which account lockout will expire. |
lockoutExpirationTimeUnit |
nvarchar (255) |
None |
Yes |
The time unit component of the period at which account lockout will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS. |
lockoutExpirationEnabled |
tinyint |
None |
No |
Whether locked accounts can programmatically re-activate. |
disallowUsernameCharEnabled |
tinyint |
None |
No |
Whether to limit the number of characters that are also in your username. |
disallowUsernameCharLimit |
smallint |
None |
No |
The limit of characters from your username allowed. |
forcePasswordChange |
tinyint |
None |
No |
Whether new actors will default to force password change. |
minimumLength |
smallint |
None |
No |
Minimum length of password. |
minimumLengthEnabled |
tinyint |
None |
No |
Whether passwords have a minimum lenght. |
passwordExpirationTimeNumber |
int |
None |
Yes |
The numerical component of the period at which the password will expire. |
passwordExpirationTimeUnit |
nvarchar (255) |
None |
Yes |
The time unit component of the period at which the password will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS. |
passwordExpirationEnabled |
tinyint |
None |
No |
Whether passwords can expire. |
passwordHistoryLength |
smallint |
None |
No |
The number of old passwords to check against. |
preventOldPasswords |
tinyint |
None |
No |
Whether to prevent old password reuse. |
repeatCharLimit |
smallint |
None |
No |
The limit of times a character can be repeated. |
repeatCharLimitEnabled |
tinyint |
None |
No |
Whether to limit the number of times a character can be repeated. |
requireLowerCase |
tinyint |
None |
No |
Whether lower case characters are required. |
requireNumeric |
tinyint |
None |
No |
Whether numeric characters are required. |
requireSpecial |
tinyint |
None |
No |
Whether special characters are required. |
requireUpperCase |
tinyint |
None |
No |
Whether upper case characters are required. |
passwordPolicyEnabled |
tinyint |
None |
No |
Whether the password policy is enabled. |
requireTermsOfService |
tinyint |
None |
No |
Whether new external users must agree to Terms of Service as part of account creation. |
identifier |
numeric (19) |
None |
No |
Unique ID for an entry. |
internalAcctExpirEnabled |
tinyint |
None |
No |
Whether internal user account expiration is enabled. |
internalAcctExpirType |
nvarchar (255) |
None |
No |
Determines how internal accounts expire. |
internalAcctExpirTimeNumber |
int |
None |
Yes |
The numerical component of the period at which internal accounts will expire. |
internalAcctExpirTimeUnit |
nvarchar (255) |
None |
Yes |
The time unit component of the period at which internal accounts will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS. |
externalAcctExpirEnabled |
tinyint |
None |
No |
Whether external user account expiration is enabled. |
externalAcctExpirType |
nvarchar (255) |
None |
No |
Determines how external accounts expire. |
externalAcctExpirTimeNumber |
int |
None |
Yes |
The numerical component of the period at which external accounts will expire. |
externalAcctExpirTimeUnit |
nvarchar (255) |
None |
Yes |
The time unit component of the period at which external accounts will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS. |