Question about table ownership

You did not include what level of Informix you are using, if you are using Informix 7 look into using ROLES. As far as who is the owner. I found having an SPECIFIC id easier to use. I know whom actually built that table. I had my administrator create me a specific id just for DBA. You must know that ONLY the owner of a table can REVOKE an USER from the table. If you have DBA auority and do not own the table then you can not revoke an user's authorization on that table. If you know you are the ONLY one who going to be using the INFORMIX id then having INFORMIX as the owner may not be a problem. Hope this helps! C.L. Kendricks