Re: Changing a table owner

Yes, but not supportably. I tried the 'obvious' trick: CREATE TABLE 'johnl'.xyz (a SERIAL NOT NULL); RENAME TABLE 'johnl'.xyz TO 'informix'.xyz; But you get a syntax error. Looking in the reference manual, you find that it documents the restriction 'new table name: you cannot use the "owner". convention in the new name of the table'. So, you are stuck with updating SysTables.Owner, and associated changes. Simply updating SysTables.Owner deals with the table, but you have to consider who should own all the indexes, constraints, triggers, and so on. You also need to consider what to do about the permissions that have been granted on the table by the original owner -- should the new owner have granted those permissions instead? And so it goes on. And, of course, updating the system catalogue via the back door like this is not supported, of course. It may be easier to drop and re-create the table after all. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From informix-list-owner@rmy.emory.edu Thu Dec 5 20:37 PST 1996 >From: "Josef Dufek" <vondr@issbrno.anet.cz> >Subject: Changing a table owner >Date: 5 Dec 1996 18:07:08 GMT >To: informix-list@rmy.emory.edu >X-Informix-List-To: johnl@informix.com >X-Informix-List-Id: <news.31263> > >Hi, > >Is it possible to change a table owner without dropping and creating >with differrent name? >It is safe to update system catalog? > >Thanks >-- >Pepa >vondr@issbrno.anet.cz > >