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 may