RE: Re[2]:date of last password change

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 19 Mar 2001 10:55:29 -0800
Message-ID: <F001.002D0C67.20010319105027@fatcity.com>

> ____________________Reply Separator____________________
> Author: "Jeffrey Beckstrom" <JBECKSTROM_at_gcrta.org>
> Date: 3/19/2001 5:05 AM
>
> anyone know of a way to find the date a user's password was
> last changed. I can
> not set up a profile with an password life time since the
> user logs in via a
> third party application which can not handle the message
> about grace logins.
> Therefore, I was going to email users when password is N days
> old. If user does
> not change then would lock user out.

I think the dba_users.expiry_date suggestion will not fit your needs since you say you DO NOT WANT to use a profile with a password life time.

Have you tried to use the column sys.user$.ptime? I tried it on a 7.3.4 database, an 8.0.5 database, and an 8.1.6 database. Here is what I seemed to notice after a password change:

- field not changed in a 7.3.4 database
- field updated in an 8.0.5 database (date and time)
- field updated in an 8.1.6 database (date only, no time)

I cannot explain the differences in behaviour between the three Oracle versions.

Try the following query:

select name, to_char (ptime, 'YYYY/MM/DD HH24:MI:SS') from sys.user$ ;

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com Received on Mon Mar 19 2001 - 12:55:29 CST