Topic
  • 1 reply
  • Latest Post - ‏2013-02-12T18:07:49Z by nivanov1
SystemAdmin
SystemAdmin
5837 Posts

Pinned topic GRANT priviliges

‏2013-02-09T08:38:20Z |
Hi!

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:
GRANT DBADM WITH DATAACCESS WITH ACCESSCTRL ON DATABASE TO USER ANOTHER_USER
everything works, but
  • if I restore a database which backup image was created on another machine and issue
GRANT DBADM WITH DATAACCESS WITH ACCESSCTRL ON DATABASE TO USER ANOTHER_USER
I get SQL0552N "locaAdmin does not have priviliges to perform operation GRANT". SQLSTATE=42502

How can I solve the problem?

Best regards,
Kovi
Updated on 2013-02-12T18:07:49Z at 2013-02-12T18:07:49Z by nivanov1
  • nivanov1
    nivanov1
    53 Posts

    Re: GRANT priviliges

    ‏2013-02-12T18:07:49Z  
    Take a look at this: http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.admin.regvars.doc/doc/r0005658.html#r0005658__S_DB2_RESTORE_GRANT_ADMIN_AUTHORITIES