grant, revoke and ownership

We are running Online 5 under AIX 3.2.5 (soon to be upgraded to 7.2 under AIX 4.1.5) Our customer requires that all tables in his system be owned by informix, even those created by other users (in ESQL-C or shell scripts). In addition many of the tables require revoking of all privilages from "public" and then granting just, say, select. Users with dba privilage have no problem creating a table owned by informix eg:- exec sql create table informix.my_name (...etc...); which creates a table with all privilages granted to public. However if the user now attempts to "revoke all on my_name from public" there are no error messages, the sqlca structure shows all zeros in the significant places and the command appears to have been executed. The same thing happens if the user does this from inside isql. BUT the information on the table shows that public still has all privilages granted. Adding "as informix" to the command has no effect. Is this a "feechur" of Online 5 or should we be doing something else / different? Peter. -- Please send e-mail to peter_jennings@uk.ibm.com