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

Sincere thank you very much for giving some insight into this.

On Wed, Oct 23, 2024 at 1:15 AM Neil Chandler <neil_chandler_at_hotmail.com> wrote:

> 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
>

-- 
Bala Rao

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