PROFILE_ID

INTEGER

Unique identifier for the profile.

PROFILE_NAME

VARCHAR

Profile name.

PASSWORD_LIFE_TIME

VARCHAR

Number of days before the user's password expires. After expiration, the user is forced to change passwords during login or warned that their password has expired if password_grace_time is set to a value other than zero or unlimited.

PASSWORD_GRACE_TIME

VARCHAR

Number of days users are allowed to log in after their passwords expire. During the grace time, users are warned about their expired passwords when they log in. After the grace period, the user is forced to change passwords if he or she hasn't already.

PASSWORD_REUSE_MAX

VARCHAR

Number of password changes that must occur before the current password can be reused.

PASSWORD_REUSE_TIME

VARCHAR

Number of days that must pass after setting a password before it can be used again.

FAILED_LOGIN_ATTEMPTS

VARCHAR

Number of consecutive failed login attempts that triggers Vertica to lock the account.

PASSWORD_LOCK_TIME

VARCHAR

Number of days an account is locked after being locked due to too many failed login attempts.

PASSWORD_MAX_LENGTH 

VARCHAR

Maximum number of characters allowed in a password.

PASSWORD_MIN_LENGTH

VARCHAR

Minimum number of characters required in a password.

PASSWORD_MIN_LETTERS

VARCHAR

The minimum number of letters (either uppercase or lowercase) required in a password.

PASSWORD_MIN_LOWERCASE_LETTERS

VARCHAR

The minimum number of lowercase.

PASSWORD_MIN_UPPERCASE_LETTERS

VARCHAR

The minimum number of uppercase letters required in a password.

PASSWORD_MIN_DIGITS

VARCHAR

The minimum number of digits required in a password.

PASSWORD_MIN_SYMBOLS 

VARCHAR

The minimum of symbols (for example, !, #, $, etc.) required in a password.