Changing table owner

How can I change the owner of a table? Thanks.

1) unload table structure and data, drop table, re-create table as the new owner, load data into table 2) use dbexport/dbimport to do the above 3) update the systables directly (informix tech support will not advise or support the outcome of this) only if you know what you're doing i think you should go with (1) after you back your database up Kleanthis

GQG wrote: >How can I change the owner of a table? dbexport the table, alter the schema, and dbimport the table. It's that hard. Randall Young ryoung@bix.com