Groups > DB2 > DB2 UDB > Re: DB2 password after network password has changed




DB2 password after network password has changed

DB2 password after network password has changed
Thu, 16 Aug 2007 11:40:09 EDT
We are new to DB2 v9.1 and have a problem/question about when a user is required
to change their windows network password and then they can no longer access DB2
tables through the ODBC driver (cli.ini).  How can this be set up to
automatically change the DB2 and CLI password to match the new network password,
or is there some other way to allow the user to access DB2 without the network
and DB2 passwords having to match.

thanks
Post Reply
Re: DB2 password after network password has changed
Fri, 17 Aug 2007 08:05:23 +020
brent@celink.com wrote:

> We are new to DB2 v9.1 and have a problem/question about when a user is
> required to change their windows network password and then they can no
> longer access DB2 tables through the ODBC driver (cli.ini).  How can this
> be set up to automatically change the DB2 and CLI password to match the
> new network password, or is there some other way to allow the user to
> access DB2 without the network and DB2 passwords having to match.

DB2 doesn't manage passwords.  It uses security plug-ins for that.  The
defaults a security plug-in that refers to the underlying operating system
for authentication.  Thus, if everything is set up properly, a change of
the user's password in the underlying security product will be
automatically in effect for DB2 as well.

So what exactly is the error message that DB2 returns? Which platform do you
run DB2 on? What do you find in the output of the "db2diag" tool?

p.s: There is only a file "db2cli.ini", which contains the
configuration of
the DB2 CLI driver.  But you shouldn't edit that file manually and use the
DB2 command UPDATE CLI CFG instead.

-- 
Knut Stolze
DB2 z/OS Utilities Development
Post Reply
about | contact