|
Problem IT35069
|
Status: Closed |
SELECT-STATEMENT INCORRECTLY RETURNS SQL20264N DURING EXECUTION
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
A select-statement may incorrectly return SQLCODE -20264,
SQLSTATE 42512 indicating the user does not have WRITE access to
the specified table. This happens when the user lacks WRITE
access on one or more LBAC protected columns, and the
select-statement is deletable or updatable (either implicitly or
explicitly). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* LBAC users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to latest fix pack *
**************************************************************** |
| Local Fix: |
Add a FOR READ ONLY clause to the select-statement |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* LBAC users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to latest fix pack *
**************************************************************** |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.11.2020
23.11.2021
23.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
