Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: user password expire
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0597C.41F47D14
Content-Type: text/plain;
charset="iso-8859-1"
You have to watch out for how to change the password when expiration happens. SQLPLUS automatically asks you what you want for a new one. Other utilities might not. I believe that you can't simply unexpire the password as the DBA. Worth checking into before you implement, even if you can stand all the phone calls (esp if they will all expire at one time). (I am speaking from experiments with Oracle's Discoverer client-server product).
-----Original Message-----
From: Holman, Rodney [mailto:rodney.holman_at_lodgenet.com]
Sent: Tuesday, November 28, 2000 10:57 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: user password expire
If you are on 8.x the answer is yes. You can use user profiles to age and force password rules.
-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com]
Sent: Tuesday, November 28, 2000 08:01 AM
To: Multiple recipients of list ORACLE-L
Subject: user password expire
Hi all -
Is there any way to set a users' password to expire every 30 days or something? I see in the doco that I can expire passwords immediately, but I don't see how I can set up recurring password expiration. I could do it through cron I guess but what a pain... !
Thanks for any suggestions
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
------_=_NextPart_001_01C0597C.41F47D14
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>user password expire</TITLE>
<META content="MSHTML 5.00.3207.2500" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=910034220-28112000>You
have to watch out for how to change the password when expiration happens.
SQLPLUS automatically asks you what you want for a new one. Other
utilities might not. I believe that you can't simply unexpire the password
as the DBA. Worth checking into before you implement, even if you can
stand all the phone calls (esp if they will all expire at one time). (I am
speaking from experiments with Oracle's Discoverer client-server
product).</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Holman, Rodney
[mailto:rodney.holman_at_lodgenet.com]<BR><B>Sent:</B> Tuesday, November 28, 2000
10:57 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>
RE: user password expire<BR><BR></DIV></FONT>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=373435415-28112000>If
you are on 8.x the answer is yes. You can use user profiles to age and
force password rules.</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Koivu, Lisa
[mailto:lkoivu_at_qode.com]<BR><B>Sent:</B> Tuesday, November 28, 2000 08:01
AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>
user password expire<BR><BR></DIV></FONT>
<P><FONT face=Arial size=2>Hi all - </FONT></P>
<P><FONT face=Arial size=2>Is there any way to set a users' password to
expire every 30 days or something? I see in the doco that I can expire
passwords immediately, but I don't see how I can set up recurring password
expiration. I could do it through cron I guess but what a pain...
!</FONT></P>
<P><FONT face=Arial size=2>Thanks for any suggestions</FONT> </P>
<P><B><FONT face=Arial size=1>Lisa Rutland Koivu</FONT></B> <BR><FONT
face=Arial size=1>Oracle Database Administrator</FONT> <BR><FONT face=Arial
size=1>Qode.com</FONT> <BR><FONT face=Arial size=1>4850 North State Road
7</FONT> <BR><FONT face=Arial size=1>Suite G104</FONT> <BR><FONT face=Arial
size=1>Fort Lauderdale, FL 33319</FONT> </P>
<P><FONT face=Arial size=1>V: 954.484.3191, x174</FONT> <BR><FONT face=Arial
size=1>F: 954.484.2933 </FONT><BR><FONT face=Arial size=1>C:
954.658.5849</FONT> <BR><FONT face=Arial size=1><A
href="http://www.qode.com" target=_blank>http://www.qode.com</A></FONT> </P>
<P><I><FONT color=#000000 face=Arial size=1>"The information contained
herein does not express the opinion or position of Qode.com and cannot be
attributed to or made binding upon
Qode.com."</FONT></I></P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
Received on Tue Nov 28 2000 - 14:46:08 CST