Is PASSWORD_ROLLOVER_TIME value in minutes or days?
The documentation I have found states the value of this profile setting is in days. However, I ran the statement below on 7 of my Oracle 19.15 databases:
ALTER PROFILE DEFAULT LIMIT PASSWORD_ROLLOVER_TIME 1;
When I run this query on all of the databases I get the following results:
select * from dba_profiles where resource_name='PASSWORD_ROLLOVER_TIME';
6 of the 7 databases return 86400 for the LIMIT and 1 of the 7 databases returns 1 for the limit.
Why would 6 of the 7 databases convert the limit into minutes?
Thanks,
Bill