RE: Oracle users and password changes
- From: "DIANNA GIBBS" <DIANNA.GIBBS@xxxxxxxxxxxxx>
- To: "Jay M Hostetter" <JHostetter@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 04 Apr 2007 12:43:38 -0500
No need to send out emails other than for notification - we'll test your
suggestion below and we will be on 10.2 by this time - thanks so much!
>>> "Hostetter, Jay M" <JHostetter@xxxxxxxxxxxxxxxxxxxx> 04/04/07 12:35 PM >>>
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DIANNA GIBBS
Sent: Wednesday, April 04, 2007 12:23 PM
To: Nick Yonko; don@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx> 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.
------------------------------------
PSU Foundation
Nick Yonko
Information Systems Director
nyonko@xxxxxxx
2125 SW 4th Ave
Suite 510
Portland, OR 97201
tel: 503 725 4909
------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Don Seiler
Sent: Wednesday, April 04, 2007 9:07 AM
To: DIANNA.GIBBS@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx> 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.
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Don Seiler
http://seilerwerks.blogspot.com
--
//www.freelists.org/webpage/oracle-l
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
