| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]:date of last password change
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" <JBECKSTROM_at_gcrta.org> Date: 3/19/2001 6:05 AM
Thought of that, but the column is null.
>>> <dgoulet_at_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_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).Received on Mon Mar 19 2001 - 10:13:18 CST
<!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">Thought
of that, but the column is null.<BR><BR>>>> <dgoulet_at_vicr.com> 3/19/01 8:50:21 AM >>><BR>AH, another well written third party application!! OH, well, it's the<BR>expiry_date in DBA_USERS.<BR><BR>Dick Goulet<BR><BR>____________________Reply Separator____________________<BR>Author: "Jeffrey Beckstrom" <JBECKSTROM_at_gcrta.org><BR>Date: 3/19/2001 5:05 AM<BR><BR>anyone know of a way to find the date a user's password was last changed. I can<BR>not set up a profile with an password life time since the user logs in via a<BR>third party application which can not handle the message about grace logins. <BR>Therefore, I was going to email users when password is N days old. If user does<BR>not change then would lock user out.<BR><BR>Jeffrey Beckstrom<BR>Database Administrator<BR>Greater Cleveland Regional Transit Authority<BR>1240 W. 6th Street<BR>Cleveland, Ohio 44113<BR>(216) 781-4204<BR><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><BR><HTML><HEAD><BR><META content="text/html; charset=iso-8859-1" http-equiv=Content-Type><BR><META content="MSHTML 5.00.3211.1700" name=GENERATOR></HEAD><BR><BODY style="FONT: 10pt Courier New; MARGIN-LEFT: 2px; MARGIN-TOP: 2px"><BR><DIV>anyone know of a way to find the date a user's password was last <BR>changed.&nbsp; I can not set up a profile with an password life time since the <BR>user logs in via a third party application which can not handle the message <BR>about grace logins.&nbsp; Therefore, I was going to email users when password is<BR><BR>N days old.&nbsp; If user does not change then would lock user out.</DIV><BR><DIV>&nbsp;</DIV><BR><DIV>Jeffrey Beckstrom<BR>Database Administrator<BR>Greater Cleveland Regional
<BR>Transit Authority<BR>1240 W. 6th Street<BR>Cleveland, Ohio
44113<BR>(216) <BR>781-4204</DIV></BODY></HTML><BR>--
<BR>Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com</A><BR>-- <BR>Author:
<BR> INET: dgoulet_at_vicr.com<BR><BR>Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR >To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR></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).
 |
 |