RE: Changing table ownership

Posted in 2001

Murray Wood — Fri, 19 Jan 2001 11:43:08 +1300 — source: Informix-list mailing list archive (1991-1998)

I know someone who lost access to the whole database doing this. systables is not the only place that refers to the owner of the table. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of JPS Sent: Wednesday, January 17, 2001 10:53 PM To: informix-list@iiug.org Subject: Changing table ownership Can anyone tell me if there is any harm done in changing the owner of a table by updating systables. It seems to work fine and the new username is also reflected in a subsequent dbschema of the table. I just want to make sure there won't be any serious repercussions later-on