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

DB2 SQL0552N error received during load when LBAC credential given to
user through role membership

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
Load, utility does not work for users in the ROLE/GROUP with 
Read/Write access, though the same user from the same role/group 
when given individual access can select, insert, update & delete 
on the table 
 
Example: 
 
db2 load client from load.del of del insert into testing.test 
 
SQL0552N  "LOADE01" does not have the privilege to perform 
operation "LOAD". SQLSTATE=42502
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Load, utility does not work for users in the ROLE/GROUP      * 
* withRead/Write access, though the same user from the         * 
* samerole/groupwhen given individual access can select,       * 
* insert, update &deleteon the tableExample:db2 load client    * 
* from load.del of del insert intotesting.testSQL0552N         * 
* "LOADE01" does not have the privilege to performoperation    * 
* "LOAD". SQLSTATE=42502                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fixpack 7 and later.              * 
****************************************************************
Local-Fix:
The problem does not occur is the user is directly granted 
access to the LBAC security label
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Upgrade to DB2 Version 9.5 Fixpack 7 and later.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC71943 IC71944 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.06.2010
20.12.2010
20.12.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP7
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList