| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com]
Sent: Tuesday, November 28, 2000 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject: 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_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-----
From: William Beilstein [ mailto:BeilstWH_at_OBG.com <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
"The information contained herein does not express the opinion or position Received on Tue Nov 28 2000 - 14:06:29 CST
 |
 |