Hi,

I would use a profile and use PASSWORD_GRACE_TIME parameter to define a grace period. In this way, every time the user logs in the system, he/she will receive an alert, remminding to change their password.

Hope this helps.
Gilson


----- Original Message -----
From: "Ilseman Jeffrey A " <oracledba-ezmlmshield-x20742434.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: Password Change Date
Date: Tue, 3 May 2005 15:59:18 -0500

>
> Is there a way to determine the date/time when a particular user's
> password was last changed?
>
> I want to have certain users change their password every 90 days, but I
> do not want to set an expiration date and lock them out.
>
>
>
> Knowing when they last changed it, I could script a "friendly" reminder
> a week or two out.
>
>
>
> Jeff Ilseman
>
> 314.554.2623
>
>
>
>
>
> *******************************
> The information contained in this message may be privileged and/or
> confidential and
> protected from disclosure. If the reader of this message is not the
> intended recipient,
> or an employee or agent responsible for delivering this message to
> the intended recipient,
> you are hereby notified that any dissemination, distribution or
> copying of this
> communication is strictly prohibited. Note that any views or
> opinions presented in this
> message are solely those of the author and do not necessarily
> represent those of Ameren.
> All emails are subject to monitoring and archival. Finally, the
> recipient should check
> this message and any attachments for the presence of viruses.
> Ameren accepts no liability
> for any damage caused by any virus transmitted by this email. If
> you have received this in
> error, please notify the sender immediately by replying to the
> message and deleting the
> material from any computer. Ameren Corporation
> *******************************
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html

--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm


Oracle LazyDBA home page