oracle - Understanding password profiles settings -


I have a question that relates to Oracle DBA, I've just read about password settings in the profile concept, PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME are a little confusing, and I think about these two topics, I am updating it, when I was reading about it, tell me if it's right or wrong.

1) PASSWORD_REUSE_MAX: This setting is used to reuse old passwords The functionality of this setting is prohibiting the reuse of old password for a few days. Example: Sql & gt; Profile Default Default PASSWORD_REUSE_MAX 180;

To assume that my current password is "abc123", I have just changed it to 'xyz123'. After few days should I change ???? Xyz123a ???? Password is the old password as 'ABC 123', but PASSWORD_REUSE_MAX has a value of 180 days. So now I am able to change a ???? Xyz123a ???? Old password for ABC 123A is not allowed, because only I can use 'ABC 123' only after 180 days as a new password.

2) PASSWORD_REUSE_TIME: It is also used for the purpose of reusing passwords. The functionality of this setting determines how many passwords change, we can set the old password as a new password. Example:

Sql & gt; Profile Default Default PASSWORD_REUSE_TIME 5 ;;

So now I can reuse the old password after 5 password changes, I explain it with the example, my old password is "abc123" ???? And just the IAC has changed it, after a few days, I want to change my existing password ???? Xyz123a ???? For "ABC 123", but in this setting it is not allowed to change. When I change the password five times with different passwords, from 6th time it allows 'abc123' as a new password.

Please thank you for your luck Bhagya Raj

What is so difficult to reference documents is?

The maximum number of password PASSWORD_USE_MAX in simple words should be changed at least to re-use the old password again.

PASSWORD_REUSE_TIME There is a restriction on the number of days that you can not use the same password before.

Generally, these two parameters should be set in conjunction with each other

For example, if you specify PASSWORD_REUSE_TIME by 30 and PASSWORD_REUSE_MAX 10 , The user can use the password again after 30 days if the password has already been changed 10 times.

You create your profile in this form,

  created profile new_profile LIMIT PASSWORD_REUSE_MAX 10 PASSWORD_REUSE_TIME 30;    

Comments

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

python - Receiving "KeyError" after decoding json result from url -

.net - Creating a new Queue Manager and Queue in Websphere MQ (using C#) -