content_image/819977.jpg content_image/819978.jpg content_image/819979.jpg
<img src='content_image/819977.jpg'>

This variable defines the global policy for controlling reuse of previous passwords based on required minimum number of password changes. For an account password used previously, this variable indicates the number of subsequent account password changes that must occur before the password can be reused. If the value is 0 (the default), there is no reuse restriction based on number of password changes. 

Changes to this variable apply immediately to all accounts defined with the PASSWORD HISTORY DEFAULT  option. 

The global number-of-changes password reuse policy can be overridden as desired for individual accounts using the PASSWORD HISTORY  option of the CREATE USER  and ALTER USER  statements. See Section 6.2.15, “Password Management” . 

• password_require_current 

<img src='content_image/819978.jpg'>

This variable defines the global policy for controlling whether attempts to change an account password must specify the current password to be replaced. 

Changes to this variable apply immediately to all accounts defined with the PASSWORD REQUIRE CURRENT DEFAULT  option. 

The global verification-required policy can be overridden as desired for individual accounts using the PASSWORD REQUIRE  option of the CREATE USER  and ALTER USER  statements. See Section 6.2.15, “Password Management” . 

• password_reuse_interval 

<img src='content_image/819979.jpg'>

