Re: How to create user account and change password?
I think many questions were asked and answered in this forum about this, so you can have detailed solution if you use the search tool.
Anyway, the answser is this I think:
- DB2 uses the OS's authentication system so you must create local users on the machine where your DB2 server is installed. (I'd be very happy to learn if any other way exists.) It's probably unnecessary to say but you can use the command;
net user <username> <password> /add
on a W2000 machine, on command line.
- About changing password: You can directly change ueser's password by following OS's user authentication rules or you can use this db2 command on db2cmd:
db2 connect to <dbname> user <username> using <oldpassword> new <newpassword> confirm <newpassword>
The db2 command above works for DB2 7.2 on Windows 2000 machine, I'm not sure if it's available on every platform.