I use this one to find accounts that are in the grace period of expiration….
select username, account_status, to_char(expiry_date, 'DD-MON-YYYY')
from dba_users
where account_status = 'EXPIRED(GRACE)'
order by expiry_date asc, username
/
You could probably mess around with some date math and expiry_date if you are
trying catch things a little sooner.
Hth,
-joe
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Bala
Sent: Thursday, August 11, 2016 1:03 PM
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject: Re: EBS R12.2.4 --Finding Password time to expire left --
Gurus,
Any query to -- identify Soon to expire schema passwords in EBS R12.2.4 -- ?
like applsys, apps,ap,po...etc
Environment - EBS R12.2.4,
Database - 12c
OS - Solaris
Thank you for your time
On Thu, Aug 11, 2016 at 3:01 PM, Bala
<oratips@xxxxxxxxx<mailto:oratips@xxxxxxxxx>> wrote:
Gurus,
Any query to -- identify Soon to expire schema passwords in R12.2.4 -- ?
--
Bala Rao
--
Bala Rao
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Although ICAT, Underwriters
at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does
not guarantee that either are virus-free and accepts no liability for any
damage sustained as a result of viruses. Thank you.