I've installed DB2 Express C and have numerous security related issues:
- The admins and users group is not created during the install even though I select OS security.
- It seems my user created with the install does not have SECADM authority and part of the script I am trying to use from a project includes granting privileges on a database to a different user (also defined to the OS). I simply get an error as follows:
SQL0552N "DB2ADMIN" does not have the privilege to perform operation "GRANT". SQLSTATE=42502
- I've tried to use Data Studio 3.1.1 Administration to update user privileges after connecting to a DB but then I do not get any expected screens, etc when I try to use the GUI to manage user privileges and I have no idea why.
Amazingly I have not been able to find much, if any, help on these topics by searching the web.
I'll admit I am not sure why this has to be so hard and complicated.