Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle users and password changes
Dianna,
If you setup a profile, ODBC should be able to handle the password change when the password expires. I've tested it on Oracle's 10.2 ODBC driver with MS Access. It will prompt for the new password. Do you have a specfic need to send out emails?
Jay
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DIANNA GIBBS
Sent: Wednesday, April 04, 2007 12:23 PM
To: Nick Yonko; don_at_seiler.us
Cc: oracle-l_at_freelists.org
Subject: RE: Oracle users and password changes
My thoughts originally were to use an email notification sending mail from within Oracle, with a link to a webpage in the email and then they could put in old password and new password...if old password compare is successful, let them change it to a new one. I haven't thought thru that whole process though and thought setting this up in multiple instances would be time consuming and a lot of maintenance. Would something like this work?
>>> "Nick Yonko" <nyonko_at_pdx.edu> 04/04/07 11:10 AM >>>
Yes, however, the notification process for those using ODBC access
through non-native Oracle app is difficult. I am looking for a solution
to this as well.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Don Seiler
Sent: Wednesday, April 04, 2007 9:07 AM
To: DIANNA.GIBBS_at_childrens.com
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle users and password changes
Precisely what user profiles are for.
http://www.adp-gmbh.ch/ora/concepts/profile.html
Don.
On 4/4/07, DIANNA GIBBS <DIANNA.GIBBS_at_childrens.com> wrote:
> We need to set up a process where Oracle users (currently few and
> mostly ODBC using Access) are notified and can change their password
> dynamically every 90 days.
>
> We were wondering what other companies do and any best practices? Any
> thoughts or comments appreciated.
>
> Thanks.
> Dianna G.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Don Seiler http://seilerwerks.blogspot.com -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business. -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 04 2007 - 12:35:32 CDT