Re: Changeing ownership of a database, and related tables

We have found that we can change the owners of informix tables by: update systables set owner="newowner" You have to be informix to do this. CAUTION: For some reason, this does not seem to be sufficient for views. You may have to drop and recreate any views that you have created on the database. (If you hear of a way to switch ownership of views, please let me know). Leonard laf@elite.com ______________________________ Reply Separator _________________________________ Subject: Changeing ownership of a database, and related tables Author: Tony Peterman <automata@netcom.com> at internet Date: 1/6/95 11:02 AM I have several databases that I need to change the database ownership, and related tables on. What is the easiest way to do this. I takes about 8 hours to unload, and reload ll the tables in a single database, so that is not the preferable option. Thanks, Tony -- _______________________________________________________________________________ Automata Consulting | P.O. Box 260798 Specializing in Network Development. | Plano, Tx. 75023-0798 Unix/C/C++ | (214)532-6063 Unix Internals | automata@netcom.com _________________________________________|_____________________________________