|
Problem IC75376
|
Status: Closed |
Table protected with the policy has dropped the select statement for the same table gives error "SQL20264N" |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When the table protected with the policy has dropped "alter
table drop security policy" the select statement for the same
table gives the error "SQL20264N" as shown below.
SQL20264N :
For table table-name, authorization ID auth-id does not have
access-type access to the column column-name.
The reason for the error "SQL20264N" :The same access plan is
used when the select statement is called on the same table after
policy drop "alter table drop security policy" is detected.
The fix for this would be to invalidate the access plan when the
command is "alter table drop security policy" detected |
| Problem Summary: |
The fix is fixed in db2 v97 FP5 |
| Local Fix: |
To issue a different statement which would cause a new access
plan to be generated |
| available fix packs: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.03.2011
12.12.2011
12.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
