|
Problem IC71769
|
Status: Geschlossen |
SECADM AUTHORITY FOR A USER MAY BE MISSED AT RUNTIME IF THAT USER ALSO HAS DBADM AUTHORITY THROUGH A ROLE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
If a user has SECADM authority and also DBADM authority via a
ROLE, under certain conditions, that users SECADM authority may
be missed at runtime. To confirm if the user has SECADM
authority or not, the user can check the authority by using
SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* If a user has SECADM authority and also DBADM authority viaa *
* ROLE, under certain conditions, that users SECADMauthority *
* may be missed at runtime. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW Version 9.5 Fixpack 7 and above *
**************************************************************** |
| Local-Fix: |
If there is one SECADM in the instance, recycle the instance and
have the SECADM user connect to the database first. If
there is more than one SECADM in the instance, the workaround
above may not work. |
| 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 |
Problem was first fixed in Version 9.5 Fixpack 7 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 07.10.2010
24.01.2011
24.01.2011 |
| 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
|
|
