I'm new to DB2, I have over 10 years of experience on Oracle.
I actually have to books on order that might help. Till then I have
been searching and reading through IBM's DB2 Information Center, as
well as manuals on IBM's website.
I'm working with DB2 because the client uses it, so enough on that
subject.
I'm trying to figure out how to change the password for a user
created in the control center. I don't like operating system
authentication, and prefer all users to specify a username and password
when logging in from anywhere. As long a scott knows the password the
user can log onto the databse and Tom or Harry, regardless of who is
logged into the OS.
I was able to change the settings in the instance paramters so that
the database itself will authenticate the user when the user attempts
to signon with a user name and password.
I created a new user using the control center, with a schema.
Unfortunately I unable to find a way to set the password for a new
user.
Under oracle it is very simple to set the user password when
creating the user or set the password for a user using the command.
alter user <dbuser> identified by <dbpassword>
Any suggestions on how to accomplish this under DB2?
Thanks in advance
Gerald