Change ownership of tables?

Posted in 2005

Topics: Versions, Editions & End-of-Life

Neil Truby — Thu, 21 Jul 2005 23:48:04 +0100 — source: Usenet: comp.databases.informix

IDS 9.40 on AIX Half the tables in the database are owned by root and half by informix. Without an export/import is there any straightforward way of changing, say, the root ones to owner informix? thanks Neil

↪ replying to Neil Truby

Esteban Casuscelli — 25 Jul 2005 03:09:52 -0700 — source: Usenet: comp.databases.informix

Neil, Update of catalog tables won't work because as far as I remember owner info is at least in the system catalog tables and slot 2 or 3 of the tbltablaspace table for each table. The update will change the system catalog tables only. Have a look at the rename statement, as one of the guys suggested it could help you in your case. esteban.-

↪ replying to Esteban Casuscelli

Chris S — 25 Jul 2005 09:03:22 -0700 — source: Usenet: comp.databases.informix

Hacking system tables can be fun, but I wouldn't suggest trying on a production system. The "rename table" statement only works in XPS, not in IDS. Been there, tried that... Your safest bet is to just unload/reload the table. -- Chris

Glossary

IDS (Informix Dynamic Server)