RE: Change ownership of tables?

Posted in 2005

Everett Mills — Thu, 21 Jul 2005 19:12:52 -0500 — source: Usenet: comp.databases.informix

Neil- I had a similar situation some years back. What I did was to vi the .sql file for the database (in the .exp directory) and type this: :g/\\"root\\"/s//\\"informix\\"/g :wq That should do it, but make a backup of the .sql file first, just in case... --EEM > -----Original Message----- > From: Neil Truby [mailto:neil.truby@ardenta.com] > Sent: Thursday, July 21, 2005 5:48 PM > To: informix-list@iiug.org > Subject: Change ownership of tables? > > 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