Re: Re:date of last password change

From: Saurabh Sharma <saurabhs_at_fcsltd.com>
Date: Mon, 19 Mar 2001 23:11:37 -0800
Message-ID: <F001.002D1360.20010319223025@fatcity.com>

but this table is not reflecting any date timestamp of such change. i 've oracle 8.0.4 on NT.

Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, March 19, 2001 7:20 PM

> AH, another well written third party application!! OH, well, it's the
> expiry_date in DBA_USERS.
>
> Dick Goulet
>
> ____________________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.
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
> (216) 781-4204
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
> <META content="MSHTML 5.00.3211.1700" name=GENERATOR></HEAD>
> <BODY style="FONT: 10pt Courier New; MARGIN-LEFT: 2px; MARGIN-TOP: 2px">
> <DIV>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.</DIV>
> <DIV> </DIV>
> <DIV>Jeffrey Beckstrom<BR>Database Administrator<BR>Greater Cleveland
Regional
> Transit Authority<BR>1240 W. 6th Street<BR>Cleveland, Ohio 44113<BR>(216)
> 781-4204</DIV></BODY></HTML>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Saurabh Sharma
  INET: saurabhs_at_fcsltd.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Mar 20 2001 - 01:11:37 CST