Changing of owner of a table

Posted in 2003

Hari Gupta — Tue, 06 May 2003 01:26:10 GMT — source: Usenet: comp.databases.informix

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 ? Thanks in advance. Hari Gupta

↪ replying to Hari Gupta

Eric Herber — Tue, 06 May 2003 08:05:17 +0200 — source: Usenet: comp.databases.informix

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 ? > > Thanks in advance. > > Hari Gupta > > It is definitely not supported by IFMX. However I did it in the past and it worked without further problems. You need to be user 'informix' to update systables.owner. You might also need to bounce the engine after this, because the data dictionary cache is not up to date. Remember to take a Level-0-Archvive before doing this and also remember that you will get no support if it doesn't work as you expect. Best regards Eric -- IT-Consulting Herber WWW: http://www.herber-consulting.de Email: eric@herber-consulting.de *********************************************** Download the IFMX Database-Monitor for free at: http://www.herber-consulting.de/BusyBee ***********************************************