RE: Change ownership of tables?

Posted in 2005

Colin Dawson — Fri, 22 Jul 2005 14:08:32 +0000 — source: Usenet: comp.databases.informix

How about running SQL to update the owner column in the approriate catalog tables. Not a recommended route I know, but it does the job. Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Neil Truby" <neil.truby@ardenta.com> >Reply-To: "Neil Truby" <neil.truby@ardenta.com> >To: informix-list@iiug.org >Subject: Change ownership of tables? >Date: Thu, 21 Jul 2005 23:48:04 +0100 > >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 > > sending to informix-list