ALTER PROFILE

Changes a profile. All parameters that are not set in a profile inherit their setting from the default profile. You can use ALTER PROFILE to change the default profile.

Syntax

ALTER PROFILE name LIMIT [ password-parameter setting ]...
PASSWORD_LIFE_TIME
PASSWORD_GRACE_TIME
FAILED_LOGIN_ATTEMPTS
PASSWORD_LOCK_TIME
PASSWORD_REUSE_MAX
PASSWORD_REUSE_TIME
PASSWORD_MAX_LENGTH
PASSWORD_MIN_LENGTH
PASSWORD_MIN_LETTERS
PASSWORD_MIN_UPPERCASE_LETTERS
PASSWORD_MIN_LOWERCASE_LETTERS
PASSWORD_MIN_DIGITS
PASSWORD_MIN_SYMBOLS

Parameters

To reset a parameter to inherit from the default profile, set its value to default.

Name Description
name

The name of the profile to create, where name conforms to conventions described in Identifiers.

To modify the default profile, set name to default. For example:

ALTER PROFILE DEFAULT LIMIT PASSWORD_MIN_SYMBOLS 1;
PASSWORD_LIFE_TIME

Set to an integer value, one of the following:

  • ≥ 1: The number of days a password remains valid.
  • UNLIMITED: Password remains valid indefinitely.

After your password's lifetime and grace period expire, you must change your password on your next login, if you have not done so already.
PASSWORD_GRACE_TIME

Set to an integer value, one of the following:

  • ≥ 1: The number of days a password can be used after it expires.
  • UNLIMITED: No grace period.
FAILED_LOGIN_ATTEMPTS

Set to an integer value, one of the following:

  • ≥ 1: The number of consecutive failed login attempts Vertica allows before locking your account.
  • UNLIMITED: Vertica allows an unlimited number of failed login attempts.
PASSWORD_LOCK_TIME

Set to an integer value, one of the following:

  • ≥ 1: The number of days your account is locked after too many failed login attempts. The account is automatically unlocked when the lock time elapses.
  • UNLIMITED: Account remains indefinitely inaccessible until a superuser manually unlocks it.
PASSWORD_REUSE_MAX

Set to an integer value, one of the following:

  • ≥ 1: The number of times you must change your password before you can reuse an earlier password.
  • UNLIMITED: You can reuse an earlier password without any intervening changes.
PASSWORD_REUSE_TIME

Set to an integer value, one of the following:

  • ≥ 1: The number of days that must pass after a password is set before you can reuse it.
  • UNLIMITED: You can reuse an earlier password immediately.
PASSWORD_MAX_LENGTH

The maximum number of characters allowed in a password, one of the following:

  • Integer between 8 and 100, inclusive
  • UNLIMITED: Maximum of 100 characters
PASSWORD_MIN_LENGTH

The minimum number of characters required in a password, one of the following:

  • 0 to PASSWORD_MAX_LENGTH
  • UNLIMITED: Minimum of PASSWORD_MAX_LENGTH
PASSWORD_MIN_LETTERS

Minimum number of letters (a‑z and A‑Z) that must be in a password, one of the following:

  • Integer between 0 and PASSWORD_MAX_LENGTH, inclusive
  • UNLIMITED: 0 (no minimum)
PASSWORD_MIN_UPPERCASE_LETTERS

Minimum number of uppercase letters (A‑Z) that must be in a password, one of the following:

  • Integer between 0 and PASSWORD_MAX_LENGTH, inclusive
  • UNLIMITED: 0 (no minimum)
PASSWORD_MIN_LOWERCASE_LETTERS

Minimum number of lowercase letters (a-z) that must be in a password, one of the following:

  • Integer between 0 and PASSWORD_MAX_LENGTH, inclusive
  • UNLIMITED: 0 (no minimum)
PASSWORD_MIN_DIGITS

Minimum number of digits (0-9) that must be in a password, one of the following:

  • Integer between 0 and PASSWORD_MAX_LENGTH, inclusive
  • UNLIMITED: 0 (no minimum)
PASSWORD_MIN_SYMBOLS

Minimum number of symbols—printable non-letter and non-digit characters such as $, #, @—that must be in a password, one of the following:

  • Integer between 0 and PASSWORD_MAX_LENGTH, inclusive
  • UNLIMITED: 0 (no minimum)

Privileges

Superuser

Profile Settings and Client Authentication

The following profile settings affect client authentication methods, such as LDAP or GSS:

  • FAILED_LOGIN_ATTEMPTS
  • PASSWORD_LOCK_TIME

All other profile settings are used only by Vertica to manage its passwords.

Example

ALTER PROFILE sample_profile LIMIT FAILED_LOGIN_ATTEMPTS 3;

See Also