I have installed DB2 Express on a PC. My user is not an administrator user, however as far as i know, it is possible to grant a user rights, so he can create/delete/modify a database.
I have executed:
after that i created a Local group:
DB2Admins, and added myself to it. After that i executed
`db2 update dbm cfg using sysadm_group db2admins.
After that i tried to
create database test, but i get the error
SQL1092N The requested command or operation failed because the user ID does not have authority to perform the requested command or operation. User ID: "myUserID".
I created a local user, and added it to the same group. If i log in with this local user, then it is ok. The user can create a a database. My user however is a domain user, and with that it is not working.
Does anyone has any idee how to solve this?
Thanks in advance!