Skip to Main Content

Oracle Database Discussions

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!

INACTIVE_ACCOUNT_TIME question

oraLaroJun 20 2022

Set this and anyone who hasnt logged in within that number of days should have their account locked.
Documentation here
Security Guide (0 Bytes)The minimum you can set it to is 15 days. Has anyone tested this and can answer following
I have a user that currently hasnt logged in for a while (lets say 50 days), I create a profile and set INACTIVE_ACCOUNT_TIME =30, assign the profile to the inactive user but nothing happens, account_status is still OPEN.
Do you have to wait 30 days from the point you applied the profile or is their an intermittent background job that runs that picks that up and locks?

Comments
Post Details
Added on Jun 20 2022
0 comments
702 views