DB2 - Problembeschreibung
Problem IC95715 | Status: Geschlossen |
SQL FUNCTION DEFINER NOT GIVEN WITH GRANT OPTION (CAN LEAD TO ERRORS LIKE SQL0551N ON LATER GRANT) | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
The definer of a SQL function should be given the WITH GRANT OPTION on the function if the definer has WITH GRANT OPTION on all privileges required to define the function, or if the definer has SYSADM or DBADM authority. However, if all of the following conditions are true, the definer is incorrectly given only EXECUTE privilege without the WITH GRANT OPTION: - The SQL function is inlined - The function definer does not have SYSADM or DBADM authority - SQL function body references one or more procedures - The function definer has the WITH GRANT OPTION on all referenced procedures This can lead to errors like SQL0551N when trying to GRANT privileges on such a function. With the conditions above all true you would see that the created function privileges in SYSCAT.ROUTINEAUTH would show a 'Y' for the 'EXECUTEAUTH' column instead of a 'G'. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5 fix pack 3 * **************************************************************** | |
Local-Fix: | |
Explicitly grant EXECUTE privilege WITH GRANT OPTION to the function definer | |
verfügbare FixPacks: | |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 version 10.5 fix pack 3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.09.2013 28.02.2014 28.02.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.3 | |
10.5.0.3 |