RE: EBS R12.2.4 --Finding Password time to expire left --

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bala Sent: Thursday, August 11, 2016 1:03 PM To: oracle-l <oracle-l_at_freelists.org> 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_at_gmail.com<mailto:oratips_at_gmail.com>> 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.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 11 2016 - 21:14:25 CEST