Informix - Problem description
Problem IT42763 | Status: Closed |
ERROR 706/111 - DBSCHEMA PRINTS GRANT STATEMENTS IN ALPHABETICALORDER | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
create procedure "informix".t1 (); select * from sysmaster:sysdual into temp tmp1; end procedure; grant execute on procedure "informix".t1 () to "a_user" with grant option as "informix"; grant execute on procedure "informix".t1 () to "z_user" as "a_user"; Run, dbschema -d db2 -f t1 -p all grant dba to "informix"; create procedure "informix".t1 (); select * from sysmaster:sysdual into temp tmp1; end procedure; grant execute on procedure "informix".t1 () to "z_user" as "a_user"; grant execute on procedure "informix".t1 () to "public" as "informix"; grant execute on procedure "informix".t1 () to "a_user" with grant option as "informix"; ... Executing above sqls in dbaccess shows, grant execute on procedure "informix".t1 () to "z_user" as "a_user"; 706: Execute privilege denied on procedure (informix.t1). 111: ISAM error: no record found. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.FC10. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.FC10. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.FC10. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.FC10. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.FC10. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.12.2022 23.02.2023 23.02.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |