I'm struggling here on how to do this I couldn't find anywhere or won't be able understand the documentation.
So I'm connected as a DBA user on a DB2 client (TOAD for example) and I want to create a new user to the database from this client, I went to the User tab, right click on it and chose the Add User option.
There is no place to add the user password. Even confirming the create command the user appears on the users list.
So I went to the command line tool and try to create a new using the
GRANT command as:
GRANT DBADM WITH DATAACCESS WITH ACCESSCTRL ON DATABASE TO USER TEST;
The user gets created (I see it on the user tab on TOAD) but I'm unable to connect with it because I didn't define the password.
So, how can I define a password for newly created user on DB2 that it is not an OS user?