RE: Changing ownership

Add indexes, permissions, constraints, anything else within the catalogue tables that refer to that table. I know someone who did it (IDS 7.2 something) and they could not use their database again. Murray Wood -----Original Message----- From: James Horn [SMTP:jmhorn@mindspring.com] Sent: Friday, August 27, 1999 4:49 AM To: Rekaish Bhardwaj; 'Andy Kent'; informix-list@iiug.org Subject: RE: Changing ownership The SQL below will do it, but be careful. Triggers/procedures might not work from other tables if they included the original owners name. mac -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Rekaish Bhardwaj Sent: Thursday, August 26, 1999 9:55 AM To: 'Andy Kent'; informix-list@iiug.org Subject: RE: Changing ownership never tried this but how about update systables set owner = ... where tabname = .... Regards Rekaish -----Original Message----- From: Andy Kent [mailto:andykent.bristol@virgin.net] Sent: Thursday, August 26, 1999 11:56 AM To: informix-list@iiug.org Subject: Changing ownership I know it's a long shot, but is there any way you can change the owner of a table without rebuilding it? Thanks, -Andy Kent- Bristol, England