Message-Id: <10694.123070@fatcity.com> From: "Koivu, Lisa" Date: Tue, 28 Nov 2000 10:01:51 -0500 Subject: 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_01C0594C.23D39CD2 Content-Type: text/plain; charset="iso-8859-1" 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@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 http://www.qode.com "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: William Beilstein [mailto:BeilstWH@OBG.com] Sent: Tuesday, November 28, 2000 9:53 AM To: ORACLE-L@fatcity.com; lkoivu@qode.com Subject: Re: user password expire Are you talking about OS or Oracle passwords? If OS, which one. >>> "Koivu, Lisa" 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 http://www.qode.com "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_01C0594C.23D39CD2 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: user password expire

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@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
http://www.qode.com

"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: William Beilstein [mailto:BeilstWH@OBG.com]
Sent: Tuesday, November 28, 2000 9:53 AM
To: ORACLE-L@fatcity.com; lkoivu@qode.com
Subject: Re: user password expire


Are you talking about OS or Oracle passwords? If OS, = which one.

>>> "Koivu, Lisa" = <lkoivu@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
http://www.qode.com

"The information contained herein does not = express the opinion or position