When does INACTIVE_ACCOUNT_TIME lock the account? (Doc ID 2879524.1)

Last updated on JULY 20, 2024

Applies to:

Goal

INACTIVE_ACCOUNT_TIME parameter, when does it lock a user?
We have a number of users that we want to lock that haven't logged in for quite some time.

Here is an example, user hasn't logged in for several years, set profile with INACTIVE_ACCOUNT_TIME 15, assign it to the user, but the user doesn't lock.

Example:

create profile test_time limit INACTIVE_ACCOUNT_TIME 15;

alter user TEST profile test_time;

select account_status, lock_Date, expiry_Date, profile, trunc(last_login), trunc(sysdate) - trunc(last_login) as days_since_login
from dba_users where username = 'TEST';

ACCOUNT_ST LOCK_DATE EXPIRY_DAT PROFILE   TRUNC(LAST_LOGIN)    DAYS_SINCE_LOGIN
----------       ----------    ----------      ---------- -------------------          ----------------
OPEN                                              TEST_TIME 22-03-2017 00:00:00        1916


 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.