|
Problem IC65334
|
Status: Closed |
Function execution blocked with SQL0551N when invoked with authenticated group from non-catalog database partition |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.5 FixPak 6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC65449
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.12.2009
05.07.2010
05.07.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.
|
| Problem solved according to the fixlist(s) of the following version(s) |
