home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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

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 FixList