DB2 - Problembeschreibung
Problem IC72579 | Status: Geschlossen |
GRANT_ADMIN_AUTHORITIES CAN FAIL, WHEN USER DOES ALREADY HAVE DATABASE LEVEL AUTHORTIES GRANTED BY SYSIBM | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
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 | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.11.2010 01.05.2011 01.05.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP4 | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |