Re: Changing Table Ownership

Herb Blacker (herbb@jcdcrs4.jobcorps.org) wrote: : I have a *very* large database (~360 tables) which will be converted from : 5.x to 7.x. In the interim, I would like to change the ownership of all : tables in the database to a single user. DOes anyone know of a simpler : way to do this besides doing a dbexport, vi'ing the file to substitute : the new owner globally, and then dbimporting the whole darned thing? : Thanks in advance, : Herb I was told you can update the syscatalog and change the owner from there. But I was also told it's dangerous because normally one would not go to modify anything in sysmaster database... -- Chris Lo mailto: cklo@hk.super.net System Administrator/Informix DBA mailto: cklo@cklo.hk.super.net The Prudential Assurance (HK) Co. Ltd mailto: paclck@hk.net ============================================================================== -- Linux + FreeBSD + HPUX + Solaris + AIX ============================================================================== #include <std/disclaimer.h>