Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Added on Apr 1 2024

1 comment

187 views