Re: Change table ownership
Posted in 1995
cherylk@spamis.jcdc.doleta.gov — — source: Informix-list mailing list archive (1991-1998)
How safe is this and is any system catalog data integrity lost? On Fri, 27 Oct 1995, Jonathan Leffler wrote: } UPDATE SysTables SET Owner = "newowner" WHERE TabName = "tablename"; } } Run as a suitably privileged user -- informix or database creator (or } maybe any DBA). Don't say I said so... } } Yours, } Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> } } >From: jmv@oh.att.com (J.M. VandeVegt) } >Date: Thu, 26 Oct 1995 20:12:34 GMT } >X-Informix-List-Id: <news.18287> } > } >Is there a way, short of unloading and recreating, to change } >the owner of an Informix SE table? }