RE: Owner changes

Dont do it. You dont need to do it. We have lots of fictious names as owners of tables -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Scott Fendley Sent: Friday, February 16, 2001 12:46 PM To: Informix Users Group Subject: Owner changes I was curious if someone had a nice little method to go through and change a large number of tables in a database to be owned by someone else. We recently lost one of our lead developers, and the remaining developers are getting the various products/projects divided among themselves. So we have a "few" tables here and there on our IDS7.x servers that I am going to have to redistribute back out. Unfortunately, it isn't so easy as doing an update on the systabnames table of sysmaster. I have seen one place where they said that you can't use this SQL statement to change ownership, but in that location in the documentation, it doesn't give me a hint of how to make the appropriate alteration. What way do you all suggest in modifying all these tables past doing a bunch of dbexports/dbimports with modifications made to the sql there? --dsf