RE: Changing ownership...

Posted in 2000

Chuck Renaud — Tue, 3 Oct 2000 07:42:40 -0500 — source: Informix-list mailing list archive (1991-1998)

Even if that technically works, it's not recommended. I believe table owners are also stored on the reserved pages. --Chuck From: LE-KIM Valerie - NTR <<Valerie.NGUYEN@sema.fr> To: Prasad Mahale <<gs0528@hotmail.com>, informix-list@iiug.org Subject: RE: Changing ownership... Date sent: Tue, 3 Oct 2000 14:17:56 +0200 <color><param>0000,0000,FF00</param>Try this SQL statement in your database:</color><FontFamily><param>Times New Roman</param><bigger> <color><param>0000,0000,FF00</param><FontFamily><param>Arial</param><smaller>UPDATE systables SET owner = '<<owner>' WHERE tabname = '<<tabname>'</color><FontFamily><param>Times New Roman</param><bigger> <paraindent><param>left</param><FontFamily><param>Tahoma</param><smaller>-----Message d'origine----- <bold>De:</bold> Prasad Mahale [mailto:gs0528@hotmail.com] <bold>Envoy':</bold> vendredi 29 septembre 2000 20:37 <bold>':</bold> informix-list@iiug.org <bold>Objet:</bold> Changing ownership... <paraindent><param>left</param><FontFamily><param>Times New Roman</param>Hi All, I want to change ownership of some of the tables in my database. The way i know is by recreating the table with new ownership info. This does'nt look easy considering my database size. Is there any easiest way, any tricks (any script?) to do this? Thanks in advance -Prasad __________________________________________________ _______________________ Get Your Private, Free E-mail from MSN Hotmail at <underline><color><param>0000,0000,FF00</param>http://www.hotmail.com</underline></color>. Share information about yourself, create your own public profile at <underline><color><param>0000,0000,FF00</param>http://profiles.msn.com</underline></color>.