Informix - Problem description
Problem IT07262 | Status: Closed |
"DBSCHEMA -HD" FAILS WITH -272 ERROR IF EXECUTED AS 'INFORMIX' AFTER SELECT PRIVILEGE IS REVOKED FROM 'PUBLIC' | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
In a database owner by non-'inofrmix' user if you revoke select privilege from 'public' on a table, then 'informix' user will be getting error "-272 No SELECT permission for <table_name>" on attempt to execute 'dbschema -hd' for that table. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC5 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IBM Informix Server 12.10.xC5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.02.2015 26.05.2015 26.05.2015 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC5 | |
12.10.xC5.W1 |