Informix - Problem description
Problem IT18741 | Status: Closed |
SELECT FROM SHOWS ALL COLUMNS, EVEN IF ONLY ACCESS TO ONE COLUMN IS PERMITTED | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
select from returns all rows of the table as a rowtype. If you create a table, and revoke the permissions, the select from will not work. However as soon as you grant select permissions to one column, the select from will return all rows of the table. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users using the OP_ROWVAR function with specific column * * access granted on the table. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Users should update to IDS 11.70.xC9 to solve this problem. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.01.2017 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |