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 |
|