|
Problem IC72579
|
Status: Closed |
GRANT_ADMIN_AUTHORITIES CAN FAIL, WHEN USER DOES ALREADY HAVE DATABASE LEVEL AUTHORTIES GRANTED BY SYSIBM |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Starting with DB2 V97 Fix Pack 2 when
DB2_RESTORE_GRANT_ADMIN_AUTHORITIES is set to ON, the
following authorities are granted to the user doing the restore:
SECADM, DBADM, DATAACCESS, and ACCESSCTRL
Until DB2 V97 Fix Pack 4 this operation will fail, when the user
doing
the restore, does already have some database level authorities
granted by SYSIBM. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 systems on all Linux, Unix and Windows platforms at *
* service levels Version 9.7 Fix Pack 2 through to Version *
* 9.7 Fix Pack 4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See "Error Description". *
****************************************************************
* RECOMMENDATION: *
* Option 1: *
* Upgrade to DB2 V97 Fix Pack 4. *
* *
* Option 2: *
* Login as the user that has SECADM authority (there always *
* exists one such entry in the SYSIBM.SYSDBAUTH catalog), If *
* the user holding SECADM does not exist on the new system *
* create it, and grant the required authorities to the user *
* that performed the restore. *
**************************************************************** |
| Local Fix: |
Grant SECADM, DBADM, DATAACCESS, and ACCESSCTRL manually to the
user that performed the restore.
Will have to login with user that has SECADM authority on the
database already to issue this grant. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Startig with DB2 V9.7 Fix Pack 4 when
DB2_RESTORE_GRANT_ADMIN_AUTHORITIES is set to ON/YES the user
performing the restore will receive
DBADM,DATAACCESS,ACCESSCTRL, and SECADM. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.11.2010
01.05.2011
01.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
