RE: user password expire

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 29 Nov 2000 10:34:34 -0000
Message-Id: <10695.123170@fatcity.com>

Lisa,

To use profiles, you also need to make sure that you have the RESOURCE_LIMIT init paramter set to true...

Regards

Mark

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Kamalakannan, D (CAP, GCF)
Sent: Tuesday, November 28, 2000 08:06
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

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

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

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

Received on Wed Nov 29 2000 - 04:34:34 CST