Database Security Products (MOSC)

MOSC Banner

Database profile resource is missing

Oracle Linux

Oracle Enterprise DB version 19.12.0.0.0


Profile resource PASSWORD_ROLLOVER_TIME seems to be missing.


Test -

CREATE PROFILE prof1

LIMIT

PASSWORD_ROLLOVER_TIME 1;


select profile, resource_name, limit from dba_profiles

where profile = 'PROF1' and resource_name like ('PASSWORD%') 

order by 2;


Missing below.

PROFILE RESOURCE_NAME          LIMIT

------- -------------------------------- ----------

PROF1  PASSWORD_GRACE_TIME       DEFAULT

PROF1  PASSWORD_LIFE_TIME        DEFAULT

PROF1  PASSWORD_LOCK_TIME        DEFAULT

PROF1  PASSWORD_REUSE_MAX        DEFAULT

PROF1  PASSWORD_REUSE_TIME       DEFAULT

PROF1  PASSWORD_VERIFY_FUNCTION     DEFAULT


6 rows selected.

In the example above PASSWORD_ROLLOVER_TIME is missing.



In a database that works, the PASSWORD_ROLLOVER_TIME resource exists as below.

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