|
Problem IC65334
|
Status: Geschlossen |
Function execution blocked with SQL0551N when invoked with authenticated group from non-catalog database partition |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
The following SQL0551N can be returned when a function from
non-catalog database partition is invoked even if it is
correctly authenticated on EXECUTE by group to which the
requester id belongs.
SQL0551N "USERXXXX" does not have the privilege to perform
operation "EXECUTE" on object "SCHEMAXXX.FUNCTIONXXX".
SQLSTATE=42501 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Multi-partitioned db user *
****************************************************************
* PROBLEM DESCRIPTION: *
* The SQL0551N can be returned when a function fromnon-catalog *
* database partition is invoked even if it iscorrectly *
* authenticated on EXECUTE by group to which therequester id *
* belongs. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 Version 9.5 FixPak 6 *
**************************************************************** |
| Local-Fix: |
There are several workaround available - they should all be
noted here explicitly, such as:
- Execute from catalog node.
- Grant explicit privilege to the user themselves
- Executing the exact same SQL which invokes the function on the
catalog node first, *may* allow non-catalog nodes to
successfully execute as well. |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
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 FixPak 6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC65449
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 28.12.2009
05.07.2010
05.07.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.
|
| Problem behoben lt. FixList in der Version |
