PROFILES
Provides information about password policies that you set using the CREATE PROFILE statement.
Provides information about password policies that you set using the CREATE PROFILE statement.
| Column Name | Data Type | Description |
|---|---|---|
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_MIN_LIFE_TIME |
VARCHAR | The number of days a password must be set before it can be reset. |
PASSWORD_MIN_CHAR_CHANGE |
VARCHAR | The minimum number of characters that must be different from the previous password when performing a password reset. |
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. |
Notes
Non-superusers querying this table see only the information for the profile to which they are assigned.