Movatterモバイル変換

ホーム

ALTER PROFILE
Prev	Up	SQL Commands	Home	Next

ALTER PROFILE

ALTER PROFILE — change an authentication profile

Synopsis

ALTER PROFILEname [ LIMITparametervalue [ ... ] ]whereparameter 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_COMPLEXALTER PROFILEname RENAME TOnew_name

Description

TheALTER PROFILE command changes parameters of aPostgres Pro profile. You must be a database superuser or have the privileges of thepg_manage_profiles role 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 byCREATE PROFILE. For more information, see theCREATE PROFILE reference page.
new_name: The new name of the profile.

Notes

UseCREATE PROFILE to add new profiles, andDROP PROFILE to remove a profile.

Examples

ChangePASSWORD_LIFE_TIME andPASSWORD_GRACE_TIME parameters of a profile:

ALTER PROFILE admin_profile    LIMIT PASSWORD_LIFE_TIME 90          PASSWORD_GRACE_TIME 3;