Users can change their password from the GUI (Configuration Assistant in
v8, was called the Client Configuration Assistant in v7).

For what it's worth, CONNECT is considered an SQL statement (it's in the
SQL Reference manual).

FBT wrote:

Blair Adamache <badamache (AT) 2muchspam (DOT) yahoo.com> wrote


There is a statement in SQL Server that goes:

Alter User [UserName] identified by [NewPassword]

Is there an equal one in DB2?

Thanks
FBT.

No. Users do not exist in DB2. DB2 uses operating system users. Here is
tha statement, which the user must enter:

connect to sample user adamache using password new newpw confirm newpw

FBT wrote:

Only two types of salespeople call their customers "users" - drug
dealers and software vendors.

Mark Townsend wrote:

Blair Adamache wrote:
Funny and prophetic - I actually described a new feature today (to a
room full of analysts), as being similar to crack cocaine - once people
started using it, they liked it so much, they couldn't stop.

If you don't want to use the Connect statement and you're concerned only
about windows stuff,
you can use WMI to change their passwords, ...
Dig around :
http://www.microsoft.com/technet/tre...ain/mngwmi.asp

Maybe also command line : net user /?

PM

"FBT" <firebladetoronto (AT) hotmail (DOT) com> a écrit dans le message de
news:859705e6.0308271021.478834d8 (AT) posting (DOT) google.com...