DB2 - Problembeschreibung
Problem IC94087 | Status: Geschlossen |
DBMS_JOB.SUBMIT() MIGHT FAIL WITH SQL0551N "DB2IM090" DOES NOT HAVE THE REQUIRED AUTHORIZATION OR PRIVILEGE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
DBMS_JOB.SUBMIT() does not react as ADMIN_TASK_ADD() in terms of authorities to run a scheduled job. DBMS_JOB.SUBMIT() systematically submit jobs as instance owner and thus, should it not have the proper execute permissions, will receive SQL0551N "DB2IM090" does not have the required authorization or privilege to perform operation "EXECUTE" on object "<object_name>". LINE NUMBER=1. SQLSTATE=42501 This error will be raised regardless of the SET SESSION AUTHORIZATION setting. The authorization will wrongly be checked against instance owner. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to version 9.7 fix pack 9 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in version 9.7 fix pack 9 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.07.2013 02.10.2013 02.10.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |