Re: Changing of owner of a table

Hari Gupta wrote: > Hi Folks, > > I am sure there have been many posts for this issue in the past but I could > not find answer to my query below. > With Informix 9.21 on Linux 6.2 - How safe is (in terms of integrity of > system catalogue) to update systables > for changing owner of a table ? Also is this update for changing owner of a > table supported by IBM ? It is fairly safe, but probably not supported by IBM. The owner of a table has little meaning, unless you are using a MODE ANSI database. If you really want to change it, then the supported method is likely to be; unload, drop, recreate and load the table. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+