Shulou(Shulou.com)05/31 Report--

This article mainly shows you "ORACLE how to set to change the password can not use the last 5 times password", the content is easy to understand, clear, hope to help you solve doubts, the following let the editor lead you to study and learn "ORACLE how to change the password can not use the last 5 times password" this article.

ORACLE cannot use the setting method of the last 5 times when changing password

Personal experiments: for example, changing the password of the Windows domain account, always changing the password leads to not remembering, but the company has set up that the last five passwords cannot be used when changing the password, and the personal tips can be changed five times every time, and the original password can be used for the fifth time, so that the previous password can be used five times, and the old password can be avoided, but ORACLE cannot do this. Because there is another parameter PASSWORD_REUSE_TIME in effect, if only PASSWORD_REUSE_MAX is changed but PASSWORD_REUSE_TIME is not modified, the previous password cannot be reused.

ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX 5

ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_TIME 30

It means that only 30 days after the password has been changed for 5 times, the previous password can be reused.

PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX

These two parameters must be set in conjunction with each other. PASSWORD_REUSE_TIME specifies the number of days before which a password cannot be reused. PASSWORD_REUSE_MAX specifies the number of password changes required before the current password can be reused. For these parameter to have any effect, you must specify a value for both of them.

If you specify a value for both of these parameters, then the user cannot reuse a password until the password has been changed the number of times specified for PASSWORD_REUSE_MAX during the number of days specified for PASSWORD_REUSE_TIME.

For example, if you specify PASSWORD_REUSE_TIME to 30 and PASSWORD_REUSE_MAX to 10, then the user can reuse the password after 30 days if the password has already been changed 10 times.

If you specify a value for either of these parameters and specify UNLIMITED for the other, then the user can never reuse a password.

If you specify DEFAULT for either parameter, then Oracle Database uses the value defined in the DEFAULT profile. By default, all parameters are set to UNLIMITED in the DEFAULT profile. If you have not changed the default setting of UNLIMITED in the DEFAULT profile, then the database treats the value for that parameter as UNLIMITED.

If you set both of these parameters to UNLIMITED, then the database ignores both of them. This is the default if you omit both parameters.

Both parameters must be set at the same time. Password_reuse_time specifies the number of days before the password cannot be reused. Password_reuse_max specifies the number of changes before the current password can be reused. You must specify values for both parameters for these to have an impact.

If you specify a value for both parameters, the user cannot reuse a password until the password has been changed the number of times specified by password_reuse_max and has exceeded the number of days specified in the parameter password_reuse_time.

For example, if you specify password_reuse_time 30 and password_reuse_max 10, if the password is changed 10 times and 30 days later, the user can reuse the password

If you specify a value for one of the parameters and infinity for the other, the user can no longer reuse the password.

If you specify default values for these two parameters, the Oracle database uses the values defined in the default configuration file. By default, all parameters in the default profile are set to unlimited. If you do not change the default settings in the default configuration file, the database treats the value of this parameter as unlimited.

If you set these two parameters to unlimited, the database ignores them. If you omit these two parameters, it is the default value.

The above is all the contents of the article "how to set up ORACLE not to use the last 5 passwords when changing passwords". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.