Changeing ownership of a database, and related tables

> 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 > ________________________________________|_____________________________________ You can change the table ownership in the system tables directly (systables, systabauth, syscolauth, et al) but by the time you learn how to do that and are sure that it's been done right far more than 8 hours will have elapsed. Given the way you have phrased the question I'd recommend you take the long, safe road. TANSTASFL! __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|