By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

Change passwd programatically?

P: n/a
Ian

The CONNECT statement allows users to change their password:

CONNECT TO DB USER user USING password NEW new_pass CONFIRM new_pass
Is it possible to do this via an application (JDBC, .NET or ODBC)?

I have been looking through the docs, but none of the properties
for the JDBC getConnection() method or the .NET
DB2Connection.ConnectionString property do not look like they have
any kind of support for this functionality.
Thanks -
Ian

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
ODBC (CLI): Use the NEWPWD attribute. For details, see uder SQLDriverConnect
in the DB2 CLI Functions.

Recommendation: Don't use passwords, use integrated authentication via
Kerberos and maintain credentials using the features of the underlying
operating system.

"Ian" <ia*****@mobileaudio.com> wrote in message
news:Pi**************************************@sidi .phx.dataproxy.com...

The CONNECT statement allows users to change their password:

CONNECT TO DB USER user USING password NEW new_pass CONFIRM new_pass
Is it possible to do this via an application (JDBC, .NET or ODBC)?

I have been looking through the docs, but none of the properties
for the JDBC getConnection() method or the .NET
DB2Connection.ConnectionString property do not look like they have
any kind of support for this functionality.
Thanks -
Ian

Nov 12 '05 #2

P: n/a
Ian
On Fri, 17 Jun 2005, Mark Yudkin wrote:
ODBC (CLI): Use the NEWPWD attribute. For details, see uder SQLDriverConnect
in the DB2 CLI Functions.
I found this after posting -- and actually was able to test it
(successfully) using ADO, which surprised me (since it's not documented
for ADO).

Recommendation: Don't use passwords, use integrated authentication via
Kerberos and maintain credentials using the features of the underlying
operating system.


Ahh, utopia.

Nov 12 '05 #3

P: n/a
"Ian" <ia*****@mobileaudio.com> wrote in message
news:Pi**************************************@sidi .phx.dataproxy.com...
On Fri, 17 Jun 2005, Mark Yudkin wrote:
ODBC (CLI): Use the NEWPWD attribute. For details, see uder
SQLDriverConnect
in the DB2 CLI Functions.
I found this after posting -- and actually was able to test it
(successfully) using ADO, which surprised me (since it's not documented
for ADO).


Actually, it should work for ADO. I can't answer your question with JDBC
though.
Recommendation: Don't use passwords, use integrated authentication via
Kerberos and maintain credentials using the features of the underlying
operating system.


Ahh, utopia.


Not really, it's what we do. It made things easy when we went to SmartCard
logons too.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.