> ____________________Reply Separator____________________
> Author: "Jeffrey Beckstrom" <[EMAIL PROTECTED]>
> 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
