DB2 - Problembeschreibung
Problem IC85410 | Status: Geschlossen |
SQL SCALAR, TABLE AND ROW FUNCTIONS MISS WITH GRANT PRIVILEGE FOR THE CREATOR IN A NON-RESTRICTIVE DATABASE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
For a normal database (non-restrictive), at database creation time, in DB2 version 9.7 PUBLIC has EXECUTE with GRANT option on 353 system routines. While in DB2 version 10.1, PUBLIC only has EXECUTE, but not the GRANT option. This becomes a problem when an user (e.g. dbusr1) creates functions that call system routines (e.g. EXPLAIN_GET_MSG). For example, if dbusr1 has EXECUTE on EXPLAIN_GET_MSG through PUBLIC only, and db2usr1 creates a function P1 which calls EXPLAIN_GET_MSG, then in DB2 version 9.7, dbusr1 would have EXECUTE with GRANT option on P1 (because dbusr1 has EXECUTE with GRANT on routines that P1 depends on, namely EXPLAIN_GET_MSG). However, in DB2 version 10.1, dbusr1 only has EXECUTE on EXPLAIN_GET_MSG (without GRANT option), so therefore dbusr1 would only have EXECUTE privilege on P1, and he would not be able to grant EXECUTE to other users. This only impacts SQL scalar, table and row functions, but not external functions or procedures. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 1 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 10.1 Fix Pack 1 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.07.2012 02.11.2012 02.11.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.1 | |
10.5.0.1 |