Password Rollover Time in Seconds

Hello,

Today, I was working on a new client database security issues. one of the first thing I checked is profile of DBA or highly privilged users. While setting PASSWORD_ROLLOVER_TIME limit in profile, I realized that even if I set it to 1 day, in DBA_PROFILES view it is listed as 86400. as anyone works in Oracle database world, I recognized this number. Number of seconds in a day. So, even if PASSWORD_ROLLOVER_TIME limit is in days, it is listed as seconds but it will be treated as DAYs. so rollover time will be 86400 days.

This is actually because of a small bug. First, you must be at least at 19.12 but even if you are on a higher version (it was 19.22 in my case) issue is still there. what you should do recreate DBA_PROFILES view. so run the script below:

Don’t forget, if this is a container database then run the script in CDB$ROOT and then in PDB. this will fixed the issue.

I hope this helps.