Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

DB profile

Roshan BisnathApr 1 2024

Oracle 19c

hello,

could you please advise on the value for PASSWORD_GRACE_TIME to get notifications for password expiry 1 month before password expire
LIMIT

     PRIVATE\_SGA UNLIMITED  
     FAILED\_LOGIN\_ATTEMPTS 3  
     PASSWORD\_LIFE\_TIME 365  
     PASSWORD\_REUSE\_TIME 31536000/86400  
     PASSWORD\_REUSE\_MAX 5  
     PASSWORD\_LOCK\_TIME 15/1440  
     **PASSWORD\_GRACE\_TIME** 432000/86400  
     INACTIVE\_ACCOUNT\_TIME UNLIMITED  
     PASSWORD\_ROLLOVER\_TIME -1/86400

Also, is there any other settings to set set on DB?

Regards,

Roshan

Comments
Post Details
Added on Apr 1 2024
1 comment
44 views