My Oracle Support Banner

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

Last updated on JULY 26, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.12.0.0.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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