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" <[EMAIL PROTECTED]>
Date: 3/19/2001 6:05 AM
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>
--
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).
