From dgoulet@vicr.com Mon, 19 Mar 2001 08:13:18 -0800 From: dgoulet@vicr.com Date: Mon, 19 Mar 2001 08:13:18 -0800 Subject: Re[2]:date of last password change Message-ID: MIME-Version: 1.0 Content-Type: text/plain I believe the column gets populated once the profile change to expire passwords gets turned on. Just checked it and it does work. It gives you the date on which their password will expire. To enable, go to the profile, set expire password on (check it) and set an expiration period & grace period. Dick Goulet ____________________Reply Separator____________________ Author: "Jeffrey Beckstrom" Date: 3/19/2001 6:05 AM Thought of that, but the column is null. >>> 3/19/01 8:50:21 AM >>> AH, another well written third party application!! OH, well, it's the expiry_date in DBA_USERS. Dick Goulet ____________________Reply Separator____________________ Author: "Jeffrey Beckstrom" 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

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

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet@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@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). Thought of that, but the column is null.

>>> <dgoulet@vicr.com> 3/19/01 8:50:21 AM >>>
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@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@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@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: INET: dgoulet@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@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).