I have a Windows Embedded POSReady 2009 with service pack 3. I've installed DB2 9.7.5 Express-C under a user (locaAdmin) that is in local Administrators group. During installation I've also enabled Extended OS security. DB2 service is running under db2admin user.
The problem I have is this:
- if I create a database under locaAdmin user, connect to it and issue:
everything works, but
- if I restore a database which backup image was created on another machine and issue
I get SQL0552N "locaAdmin does not have priviliges to perform operation GRANT". SQLSTATE=42502
How can I solve the problem?