Postgres Pro Standard : Documentation: 17: ALTER PROFILE : Postgres Professional

ALTER PROFILE
Prev	Up	SQL Commands	Home	Next

ALTER PROFILE

ALTER PROFILE — change an authentication profile

Synopsis

ALTER PROFILE name [ LIMIT parameter value [ ... ] ]

where parameter can be:

      FAILED_LOGIN_ATTEMPTS
    | PASSWORD_REUSE_TIME
    | PASSWORD_REUSE_MAX
    | PASSWORD_LIFE_TIME
    | PASSWORD_GRACE_TIME
    | USER_INACTIVE_TIME
    | FAILED_AUTH_KEEP_TIME
    | PASSWORD_MIN_UNIQUE_CHARS
    | PASSWORD_MIN_LEN
    | PASSWORD_REQUIRE_COMPLEX

ALTER PROFILE name RENAME TO new_name

Description

The ALTER PROFILE command changes parameters of a Postgres Pro profile. You must be a database superuser or have the privileges of the pg_manage_profiles role to use this command.

Parameters

name: The name of the profile for which to alter parameters.
FAILED_LOGIN_ATTEMPTS value PASSWORD_REUSE_TIME value PASSWORD_REUSE_MAX value PASSWORD_LIFE_TIME value PASSWORD_GRACE_TIME value USER_INACTIVE_TIME value FAILED_AUTH_KEEP_TIME value PASSWORD_MIN_UNIQUE_CHARS value PASSWORD_MIN_LEN value PASSWORD_REQUIRE_COMPLEX value: These clauses alter parameters originally set by CREATE PROFILE. For more information, see the CREATE PROFILE reference page.
new_name: The new name of the profile.

Notes

Use CREATE PROFILE to add new profiles, and DROP PROFILE to remove a profile.

Examples

Change PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME parameters of a profile:

ALTER PROFILE admin_profile
    LIMIT PASSWORD_LIFE_TIME 90
          PASSWORD_GRACE_TIME 3;