Re: Oracle 19c : How to lock user based on "PASSWORD_LIFE_TIME"

Bala,

The time based settings in DBA_PROFILES do not necessarily get enacted as soon as their time is reached. They are queried by MMON (I think) and if it’s past the expiration date/time, the account is expired. This can be a delay of several hours - which is worth understanding if you make changes to a profile as it may well not take effect until much later when, you have gone home. :-)

If you need more timely intervention, I would write my own scheduler job to query the metric and lock the account. I’d avoid looking for internal (unsupported?) “tweaks” to settings to make it more regular, and avoid unwanted consequences of that.

Neil Chandler
sent from my phone

> On 23 Oct 2024, at 04:55, Bala <oratips_at_gmail.com> wrote:
>
> 
> Gurus
>
> Any way to "Lock account" as soon as "PASSWORD_LIFE_TIME" value is reached ?.
>
> I am thinking account_status goes to "EXPIRED" and if they attempt to log in, it gets "LOCKED" thereafter - is this correct understanding ?
>
> Any way to lock the account as soon as "PASSWORD_LIFE_TIME" is reached ?
>
> Thank you all for any insight and help.
> --
> Bala Rao

--
http://www.freelists.org/webpage/oracle-l