Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center