Account Security Properties#
CASE_SENSITIVE_PASSWORD#
Data Type#
Unsigned Integer
Default Value#
0
Attributes#
Read-Write, Single Value
Range#
[0, 1]
Description#
This specifies whether or not the database is to distinguish between uppercase and lowercase letters in user passwords. The default value for this property is 0 (case-insensitive), which means that the database treats user passwords as uppercase letters.
- 0: Does not distinguish between uppercase and lowercase letters (case-insensitive).
- 1: Distinguishes between uppercase and lowercase letters (case sensitive); however, only if passwords are enclosed in quotation marks (") in the CREATE USER statement. Passwords which are not enclosed in quotation marks are treated as uppercase letters.
The value of this property can be changed using the ALTER SYSTEM statement while Altibase is running.
FAILED_LOGIN_ATTEMPTS#
Data Type#
Unsigned Integer
Default Value#
0
Attributes#
Read-Only, Single Value
Range#
[0, 1000]
Description#
If an attempt to log in fails more than number of times set in this property, the account cannot be logged in.
PASSWORD_LOCK_TIME#
Data Type#
Unsigned Int
Default Value#
0
Attributes#
Read-Only, Single Value
Range#
[0, 3650]
Description#
This specifies the date(unit: days) required to elapse for a locked account to become unlocked.
PASSWORD_LIFE_TIME#
Data Type#
Unsigned Integer
Default Value#
0
Attributes#
Read-Only, Single Value
Range#
[0, 3650]
Description#
This specifies the period of validity(unit: days) for the account password.
PASSWORD_GRACE_TIME#
Data Type#
Unsigned Integer
Default Value#
0
Attributes#
Read-Only, Single Value
Range#
[0, 3650]
Description#
This property specifies the grace period (unit: days) after the expiry date of the account password.
PASSWORD_REUSE_TIME#
Data Type#
Unsigned Integer
Default Value#
0
Attributes#
Read-Only, Single Value
Range#
[0, 3650]
Description#
This specifies the period of time(unit: days) needed to elapse for the reuse of identical passwords. Thus, identical passwords can be reused after the period of time specified for this option elapses.
PASSWORD_REUSE_MAX#
Data Type#
Unsigned Integer
Default Value#
0
Attributes#
Read-Only, Single Value
Range#
[0, 1000]
Description#
This specifies the number of times passwords can be altered for the reuse of identical passwords. Thus, identical passwords can be reused after they have been altered for the number of times specified by this option.
PASSWORD_VERIFY_FUNCTION#
Data Type#
String
Default Value#
""
Attributes#
Read-Only, Single Value
Range#
Maximum length : 40 bytes
Description#
This specifies a user-defined CALLBACK function for verifying passwords.