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 IC67008 Status: Geschlossen

SECURITY: SYSTEM GRANTED PRIVILEGES NOT REGENERATED ON VIEWS WHE
NAUTO_REVAL IS SET TO IMMEDIATE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When a view is created on a base object, such as a table or 
another view, there is a set of privileges granted by the 
database manager to the definer of the dependent view.  If the 
AUTO_REVAL database configuration parameter is set to IMMEDIATE, 
then system privileges are supposed to be re-granted for the 
owner of the view when the base object is recreated, however, 
they are not.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 Version 9.7 GA through to Fix Pack 1 servers on      * 
* Linux, Unix and Windows environments running with AUTO_REVAL * 
* set to IMMEDIATE.                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* System privileges on views dependent on base objects do not  * 
* have privileges re-granted when the base objects are         * 
* redefined.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Set AUTO_REVAL database configuration parameter to DEFERRED  * 
* while performing maintenance on objects.  Otherwise, ensure  * 
* to always drop and recreate dependent views when base        * 
* objects are redefined, or apply DB2 Version 9.7 Fix Pack 2   * 
* to obtain the fix.                                           * 
****************************************************************
Local-Fix:
Set AUTO_REVAL database configuration parameter to DEFERRED 
while performing maintenance on objects.  Otherwise, recreate 
the dependent view to pick up the correct system granted 
privileges.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows

Lösung
Problem is first fixed in DB2 Version 9.7 Fix Pack 2 and all 
subsequence Fix Packs.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC67034 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.03.2010
26.04.2010
20.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList