PASSWORD_ROLLOVER_TIME parameter value does not reflect in the profile
(Doc ID 3037012.1)
Last updated on SEPTEMBER 08, 2024
Applies to:
Gen 2 Exadata Cloud at Customer - Version N/A to N/A [Release All Releases]Oracle Database - Enterprise Edition - Version 19.16.0.0.0 and later
Oracle Database Cloud Exadata Service - Version N/A to N/A [Release 1.0]
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Symptoms
Password_rollover_time is zero in a profile when queried using below query
select PROFILE, RESOURCE_NAME from DBA_PROFILES where RESOURCE_NAME ='PASSWORD_ROLLOVER_TIME';
Created a profile with PASSWORD_ROLLOVER_TIME but when checking to see if that value is reflected in the profile does not return any row.
SQL> CREATE PROFILE Cprof1 LIMIT PASSWORD_ROLLOVER_TIME 1;
Profile created.
SQL> SELECT PROFILE, RESOURCE_NAME, LIMIT from DBA_PROFILES WHERE RESOURCE_NAME ='PASSWORD_ROLLOVER_TIME';
no rows selected
Changes
Applied DBRU from 19.3 to 19.16.
Note: Password_rollover_time can be seen from 19.12 RU
https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features-19c-release-updates.html#GUID-F9947CEF-0571-43AD-8617-E50C1158BB72
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 |