Re: Changing ownership of tables

What "ramnaby" says will work, but there are cautions/caveats, namely: - Informix Tech Support won't support this - Make SURE you back up the engine before you do it, in case you screw something up. - Make sure you fix the owner EVERYWHERE. In addition to systables, you also need to update sysindexes, sysconstraints, and sysobjstate at the very least. ramnabv@my-dejanews.com wrote in message <72egpk$kjn$1@nnrp1.dejanews.com>... > > >One way could be to change the owner name of the table in the system >catalog 'systables' directly. > >-ramana > >In article <72cif6$hei$1@news.xmission.com>, > Alanoly Andrews <AlanolyA@planmatics.com> wrote: >> >> >> Once a table is created, is it possible to change the ownership >> of the table without recreating it? For Informix database access >> from programs like MS Access and Excel (which require an ownername >> prefix whenever a table is mentioned), we would like to change >> ownership of all existing tables to "root". >> I'd appreciate pointers on how to do this. Thanks. >> >> Informix Online Version 7.22 UC2 on AIX 4.1.4 >> >> Alanoly J. Andrews >> >> > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own