Change passwd programatically?

[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

[Mark Yudkin]

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

[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.

[Mark Yudkin]

"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.