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

Administrative views return duplicated rows, although should return one,
when multiple sources of rights exist in ORA mode.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
When DB2_COMPATIBILITY_VECTOR is set to ORA,  administrative 
views(all_tables, all_views etc.) the views returns duplicated 
results when more then one sources of rights exist. 
 
db2stop 
db2set DB2_COMPATIBILITY_VECTOR=ORA 
db2start 
db2sampl 
db2 connect to sample 
db2 "CREATE TABLE t1(c1 int)" 
db2 "CREATE ROLE role_test" 
db2 "CREATE ROLE role_test2" 
db2 "GRANT SELECT ON t1 TO role_test, role_test2" 
db2 "grant role role_test to user1" 
db2 "grant role role_test2 to user1" 
 
db2 -x "select * from all_tables where table_name='T1'" 
 
Result for current user: 
 
DB2INST1 DB2INST1 T1 IBMDB2SAMPLEREL -1 262144 262144 0 YES 0 0 
1 0 DISABLED 2011-10-12-13.45.14.336171 YES N IBMDEFAULTBP YES 
DISABLED 
 
Result for user1: 
 
DB2INST1 DB2INST1 T1 IBMDB2SAMPLEREL -1 262144 262144 0 YES 0 0 
1 0 DISABLED 2011-10-12-13.45.14.336171 YES N IBMDEFAULTBP YES 
DISABLED 
 
DB2INST1 DB2INST1 T1 IBMDB2SAMPLEREL -1 262144 262144 0 YES 0 0 
1 0 DISABLED 2011-10-12-13.45.14.336171 YES N IBMDEFAULTBP YES 
DISABLED
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* See Error Description                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See Error Description                                        * 
****************************************************************
Local-Fix:
Can add UNIQUE to the select to remove the duplicate rows.
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.06.2012
06.11.2012
06.11.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.1 FixList
10.5.0.1 FixList