DB2 - Problembeschreibung
Problem IC71262 | Status: Geschlossen |
PRIVILEGES MIGHT NOT BE PICKED UP IF THEY ARE GRANTED TO A ROLE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
Privileges granted to a role might not be recognized if: 1) If a user belonging to a group, and the role is granted to the group, and the name for the group and the role are the same. 2) If a user directly belongs to a role, and the user name and the role name are the same. As a result, the user might get SQL0551N error when issuing SQL statements. SQL0551N "JOHN" does not have the required authorization or privilege to perform operation "SELECT" on object "MYSCHEMA.MYTABLE". SQLSTATE=42501 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All DB2 systems on all Linux, Unix and Windows platforms at * * service levels from Version 9.5 GA through to Version 9.5 * * Fix Pack 6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 7. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
The complete fix for this problem first appears in DB2 Version 9.5 Fix Pack 7 and all the subsequent Fix Packs. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC71266 IC71267 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 16.09.2010 15.11.2010 15.11.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP7 | |
Problem behoben lt. FixList in der Version | |
9.1.0.7 | |
9.5.0.7 |