| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> THANKS: 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_01C05A01.46E1697E
Content-Type: text/plain;
charset="iso-8859-1"
Thanks everyone for your replies.
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."
-----Original Message-----
From: Kamalakannan, D (CAP, GCF) [mailto:D.Kamalakannan_at_gecapital.com]
Sent: Tuesday, November 28, 2000 3:06 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: user password expire
Lisa,
I tried the same in my test database both by creating a new profile like
default and changing the PASSWORD_LIFE_TIME and by using it in the default
profile - both of which did not result in any error as you have mentioned. I
am using Oracle 8.1.6 on NT.
I am not sure why you get the error!
Incase if you do have a Oracle Security Manager it is quite easy to change
in the way you wanted.
Regards,
kamal
-----Original Message-----
Sent: Tuesday, November 28, 2000 3:01 PM
To: Multiple recipients of list ORACLE-L
The Oracle password. I've been messing with the profiles, but once I set PASSWORD_LIFE_TIME, PASSWORD_REUSE_TIME and PASSWORD_GRACE_TIME I got some odd error :
SQL> alter profile default limit password_life_Time 30;
Profile altered.
SQL> connect user/pw_at_qodd
ERROR:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
Warning: You are no longer connected to ORACLE. SQL> So I set it back to unlimited. I also tried setting it to 10/2000 and got the same error.
Bueller? Bueller?
Thanks
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."
-----Original Message-----
]
Sent: Tuesday, November 28, 2000 9:53 AM
To: ORACLE-L_at_fatcity.com; lkoivu_at_qode.com
Are you talking about OS or Oracle passwords? If OS, which one.
>>> "Koivu, Lisa" <lkoivu_at_qode.com> 11/28/00 09:00AM >>>
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."
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kamalakannan, D (CAP, GCF) INET: D.Kamalakannan_at_gecapital.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). ------_=_NextPart_001_01C05A01.46E1697E Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>THANKS: user password expire</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Thanks everyone for your replies. </FONT> </P> <BR> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>"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></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Kamalakannan, D (CAP, GCF) [<A = HREF=3D"mailto:D.Kamalakannan_at_gecapital.com">mailto:D.Kamalakannan_at_gecap= ital.com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, November 28, 2000 3:06 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: user password expire</FONT> </P> <BR> <P><FONT SIZE=3D2>Lisa,</FONT> <BR><FONT SIZE=3D2>I tried the same in my test database both by = creating a new profile like</FONT> <BR><FONT SIZE=3D2>default and changing the PASSWORD_LIFE_TIME and by = using it in the default</FONT> <BR><FONT SIZE=3D2>profile - both of which did not result in any error = as you have mentioned. I</FONT> <BR><FONT SIZE=3D2>am using Oracle 8.1.6 on NT.</FONT> <BR><FONT SIZE=3D2>I am not sure why you get the error!</FONT> <BR><FONT SIZE=3D2>Incase if you do have a Oracle Security Manager it = is quite easy to change</FONT> <BR><FONT SIZE=3D2>in the way you wanted.</FONT> <BR><FONT SIZE=3D2>Regards,</FONT> <BR><FONT SIZE=3D2>kamal</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, November 28, 2000 3:01 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>The Oracle password. I've been messing with the = profiles, but once I set</FONT> <BR><FONT SIZE=3D2>PASSWORD_LIFE_TIME, PASSWORD_REUSE_TIME and = PASSWORD_GRACE_TIME I got some</FONT> <BR><FONT SIZE=3D2>odd error :</FONT> </P> <P><FONT SIZE=3D2>SQL> alter profile default limit = password_life_Time 30; </FONT> </P> <P><FONT SIZE=3D2>Profile altered. </FONT> </P> <P><FONT SIZE=3D2>SQL> connect user/pw_at_qodd </FONT> <BR><FONT SIZE=3D2>ERROR: </FONT> <BR><FONT SIZE=3D2>ORA-01841: (full) year must be between -4713 and = +9999, and not be 0 </FONT> </P> <BR> <P><FONT SIZE=3D2>Warning: You are no longer connected to ORACLE. = </FONT> <BR><FONT SIZE=3D2>SQL> </FONT> </P> <P><FONT SIZE=3D2>So I set it back to unlimited. I also tried = setting it to 10/2000 and got</FONT> <BR><FONT SIZE=3D2>the same error. </FONT> </P> <P><FONT SIZE=3D2>Bueller? Bueller? </FONT> </P> <P><FONT SIZE=3D2>Thanks </FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu </FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator </FONT> <BR><FONT SIZE=3D2>Qode.com </FONT> <BR><FONT SIZE=3D2>4850 North State Road 7 </FONT> <BR><FONT SIZE=3D2>Suite G104 </FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319 </FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174 </FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849 </FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A> <<A = HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A>> </FONT> </P> <P><FONT SIZE=3D2>"The information contained herein does not = express the opinion or position</FONT> <BR><FONT SIZE=3D2>of Qode.com and cannot be attributed to or made = binding upon Qode.com."</FONT> </P> <BR> <P><FONT SIZE=3D2>-----Original Message----- </FONT> <BR><FONT SIZE=3D2>] </FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, November 28, 2000 9:53 AM </FONT> <BR><FONT SIZE=3D2>To: ORACLE-L_at_fatcity.com; lkoivu_at_qode.com </FONT> </P> <BR> <P><FONT SIZE=3D2>Are you talking about OS or Oracle passwords? If OS, = which one. </FONT> </P> <P><FONT SIZE=3D2>>>> "Koivu, Lisa" = <lkoivu_at_qode.com> 11/28/00 09:00AM >>> </FONT> <BR><FONT SIZE=3D2>Hi all - </FONT> </P> <P><FONT SIZE=3D2>Is there any way to set a users' password to expire = every 30 days or </FONT> <BR><FONT SIZE=3D2>something? I see in the doco that I can expire = passwords immediately, but I</FONT> </P> <P><FONT SIZE=3D2>don't see how I can set up recurring password = expiration. I could do it </FONT> <BR><FONT SIZE=3D2>through cron I guess but what a pain... ! </FONT> </P> <P><FONT SIZE=3D2>Thanks for any suggestions </FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu </FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator </FONT> <BR><FONT SIZE=3D2>Qode.com </FONT> <BR><FONT SIZE=3D2>4850 North State Road 7 </FONT> <BR><FONT SIZE=3D2>Suite G104 </FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319 </FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174 </FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849 </FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A> <<A = HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A>> </FONT> </P> <P><FONT SIZE=3D2>"The information contained herein does not = express the opinion or position </FONT> <BR><FONT SIZE=3D2>of Qode.com and cannot be attributed to or made = binding upon Qode.com." </FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Kamalakannan, D (CAP, GCF)</FONT> <BR><FONT SIZE=3D2> INET: D.Kamalakannan_at_gecapital.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =Received on Wed Nov 29 2000 - 06:38:29 CST
 |
 |