Changing ownership of tables

Posted in 1998

Alanoly Andrews — Wed, 11 Nov 1998 12:05:09 -0500 — source: Informix-list mailing list archive (1991-1998)

Once a table is created, is it possible to change the ownership of the table without recreating it? For Informix database access from programs like MS Access and Excel (which require an ownername prefix whenever a table is mentioned), we would like to change ownership of all existing tables to "root". I'd appreciate pointers on how to do this. Thanks. Informix Online Version 7.22 UC2 on AIX 4.1.4 Alanoly J. Andrews