RE: user password expire

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Tue, 28 Nov 2000 10:01:51 -0500
Message-Id: <10694.123070@fatcity.com>

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_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

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_at_OBG.com] Sent: Tuesday, November 28, 2000 9:53 AM To: ORACLE-L_at_fatcity.com; lkoivu_at_qode.com Subject: Re: user password expire

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

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

<!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>RE: user password expire</TITLE>
</HEAD>
<BODY>

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
 <A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A>


"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 [<A =
HREF=3D"mailto:BeilstWH_at_OBG.com">mailto:BeilstWH_at_OBG.com</A>]
 Sent: Tuesday, November 28, 2000 9:53 AM
 To: ORACLE-L_at_fatcity.com; lkoivu_at_qode.com
 Subject: Re: user password expire

 

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


"The information contained herein does not =
express the opinion or position Received on Tue Nov 28 2000 - 09:01:51 CST