Re: password change timestamp

From: Joe Kazimierczyk <joekazimierczyk_at_netscape.net>
Date: 27 Sep 2002 03:55:08 -0700
Message-ID: <236e8fc1.0209270255.61363347@posting.google.com>

"Murty Adavi" <adavi_at_attbi.com> wrote in message news:<l8Ok9.2254$bX.185_at_sccrnsc02>...
> Is there any way of finding out last password change timestamp without
> truning on auditing ?

Beginning in 8i, you can use sys.user$.ptime

But if you want to avoid using the base sys tables, and if you have profiles setup for password_life_time, you can figure it out by using that password_life_time value along with dba_users.expiry_date. Received on Fri Sep 27 2002 - 05:55:08 CDT