|
Problem IC62206
|
Status: Closed |
WHEN DEPLOYING ROUTINES WITH VISUAL STUDIO .NET ADD-INS, PRIVILE GES ARE BEING TAKEN INTO CONSIDERATION WHEN THEY SHOULD NOT BE |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
When updating and redeploying a stored procedure using the
Visual Studio .NET add-ins, a GRANT or REVOKE operation may
be issued after the stored procedure is compiled. This GRANT
or REVOKE operation may be unexpected and could ultimately
cause the deployment of the stored procedure to fail, if the
GRANT/REVOKE operation fails.
.
This may happen even if no privileges are defined for the
stored procedure.
.
This problem is more likely to happen against a DB2 for z/OS v9
server. |
| Problem Summary: |
Users Affected: Visual Studio .NET addin users
Problem Description:
When updating and redeploying a stored procedure using the
Visual Studio .NET add-ins, a GRANT or REVOKE operation may
be issued after the stored procedure is compiled. This GRANT
or REVOKE operation may be unexpected and could ultimately
cause the deployment of the stored procedure to fail, if the
GRANT/REVOKE operation fails. |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.7, Fixpak 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.07.2009
22.12.2009
22.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
