Re: Changing Table Ownership

jjjjjMr Cheuk Kong Lo wrote: > > Herb Blacker (herbb@jcdcrs4.jobcorps.org) wrote: > : I have a *very* large database (~360 tables) which will be converted > from > : 5.x to 7.x. In the interim, I would like to change the ownership of > all > : tables in the database to a single user. DOes anyone know of a > simpler > : way to do this besides doing a dbexport, vi'ing the file to > substitute > : the new owner globally, and then dbimporting the whole darned thing? > : Thanks in advance, > : Herb > > I was told you can update the syscatalog and change the owner from > there. > But I was also told it's dangerous because normally one would not go > to modify anything in sysmaster database... The owner column is in the systables table in YOUR database, not in the sysmaster database. And yes, you update it at your own risk. Though I know of people who have done this. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+