Thought of that, but the column is null. >>> <[EMAIL PROTECTED]> 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" <[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. 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
<!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>>>> <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]><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: [EMAIL PROTECTED]<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: [EMAIL PROTECTED] (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>
