RE: Password changed date in 8.1.7

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Mon, 16 Oct 2006 09:20:32 -0500
Message-ID: <F184F089F3A34E428AA57BB0D43626ED78D386@MSPM1BMSGM04.ent.core.medtronic.com>

select name, ptime from sys.user$ where name='<username>';

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: Monday, October 16, 2006 9:09 AM
To: oracle-l_at_freelists.org
Subject: Password changed date in 8.1.7

Where does Oracle store the date when a user's password was last changed in 8.1.7? I would have expected it to be in dba_users but it is not there?

Thanks,
Peter Schauss
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 16 2006 - 09:20:32 CDT