Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: user password expire
To my Knowledge there is a provision to set the password life time in the
Profile Level in versions of Oracle 8 and over.
Here is an example to set it in already created profile
The following statement modifies profile PROF's PASSWORD_LIFE_TIME to 60 days and PASSWORD_GRACE_TIME to 10 days:
ALTER PROFILE prof LIMIT
PASSWORD_LIFE_TIME 60
PASSWORD_GRACE_TIME 10;
While you can create a Profile like this
The following statement creates profile MYPROFILE with password profile
limits values set:
CREATE PROFILE myprofile LIMIT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LIFE_TIME 60 PASSWORD_REUSE_TIME 60 PASSWORD_REUSE_MAX UNLIMITED PASSWORD_VERIFY_FUNCTION verify_function PASSWORD_LOCK_TIME 1/24 PASSWORD_GRACE_TIME 10;
Regards,
Kamal
-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
Sent: Tuesday, November 28, 2000 3:41 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: user password expire
Lisa,
When you create or alter a user using OEM there is an option to expire the password now. The command is 'alter user USERNAME password expire;' but if you try to look it up in the doc's there is nothing.
Sorry I couldn't be of real help. Enter an iTAR in Metalink and see what the 'experts' have to say.
Regards,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, November 28, 2000 9:00 AM
> 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."
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us 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 mayReceived on Tue Nov 28 2000 - 11:48:58 CST