Name: Postgres Pro Standard : Documentation: 14: ALTER PROFILE : Postgres Professional
Rating: 4.4 (4539 reviews)

ALTER PROFILE
Prev	Up	SQL Commands	Home	Next

ALTER PROFILE

ALTER PROFILE — change an authentication profile

Synopsis

 ALTER PROFILE name [ LIMIT parametervalue [ ... ] ] 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 to use this command.

Parameters

name: The name of the profile for which to alter parameters.
FAILED_LOGIN_ATTEMPTSvalue PASSWORD_REUSE_TIMEvalue PASSWORD_REUSE_MAXvalue PASSWORD_LIFE_TIMEvalue PASSWORD_GRACE_TIMEvalue USER_INACTIVE_TIMEvalue FAILED_AUTH_KEEP_TIMEvalue PASSWORD_MIN_UNIQUE_CHARSvalue PASSWORD_MIN_LENvalue PASSWORD_REQUIRE_COMPLEXvalue: 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;