Oracle 19c : How to lock user based on "PASSWORD_LIFE_TIME"
From: Bala <oratips_at_gmail.com>
Date: Tue, 22 Oct 2024 22:53:10 -0500
Message-ID: <CAF5SaXu3Lw_k9csueHaobRMOb_3pfZxZUJ2AswiJczyD1A-GVQ_at_mail.gmail.com>
Gurus
Date: Tue, 22 Oct 2024 22:53:10 -0500
Message-ID: <CAF5SaXu3Lw_k9csueHaobRMOb_3pfZxZUJ2AswiJczyD1A-GVQ_at_mail.gmail.com>
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
Received on Wed Oct 23 2024 - 05:53:10 CEST