DB2 - Problembeschreibung
Problem IC75376 | Status: Geschlossen |
Table protected with the policy has dropped the select statement for the same table gives error "SQL20264N" | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
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 | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.03.2011 12.12.2011 12.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |