Re: Change table ownership

I've never had any problem with this, and I've done it a few times... ( The end result of doing something without thinking about which user I'm logged in as... ) I've never seen any evidence ofany database integrity problem ( even after a few years ). We are running Online, not SE, but that shouldn't make any difference to that level of operation... Anthony Burkitt Geac Australia > >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> >}