Alter Profile Set PASSWORD_ROLLOVER_TIME - Limit Is Saved In Secs
(Doc ID 2815172.1)
Last updated on OCTOBER 18, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 19.12.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
PASSWORD_ROLLOVER_TIME limit showing value in seconds.
SQL> ALTER PROFILE NORMAL_USERS LIMIT PASSWORD_ROLLOVER_TIME 10; >>> set to 10 days
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------- -------------------------------- -------- ------------------------------
NORMAL_USERS PASSWORD_ROLLOVER_TIME PASSWORD 864000 >>> showing in seconds
SQL> alter profile USR_PROF limit PASSWORD_ROLLOVER_TIME 0; >>> to disable
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------- -------------------------------- -------- ------------------------------
USR_PROF PASSWORD_ROLLOVER_TIME PASSWORD -1
Changes
After apply RU 19.12, the DBA_PROFILES view is not updated.
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 |
| Changes |
| Cause |
| Solution |
| References |