PASSWORD_LOCK_TIME Is Not Setting Correctly
(Doc ID 2923653.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Trying to set a the profile's PASSWORD_LOCK_TIME as follows:
alter profile default limit PASSWORD_LOCK_TIME 0.0208;
select * from dba_profiles where profile='DEFAULT' and RESOURCE_NAME='PASSWORD_LOCK_TIME';
PROFILE RESOURCE_NAME RESOURCE LIMIT
---------------------------------------------------------------------------------------------------------------------
DEFAULT PASSWORD_LOCK_TIME PASSWORD .0207 (It shows .0207 instead of .0208)
e.g Testing values from .0200 to .0218 We found 11 values were set rightly but .0202,.0205,.0207,.0208,.0210,.0211,.0213 and .0216 set an incorrect value (one decimal lower to the current one).
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |