Re: Changeing ownership of a database, and related tables

leonard (leonard@ccmail.elite.com) wrote: > 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). > Without any qualifiers, it would seem that the above would also change the ownership of the informix sys* tables. That would not be good. If you wanted to try a "one shot does all" approach, the above sql *probably* would be safe to run -- just qualify it with tabid > 99 and tabtype = "T" for tables and tabtype = "V" for views. Alternatively, you could use the "rename table" command and include the new ownership in the table name. -- Carlton Doe "It's not *over* until I win!" DBA Resources, Inc. -- Les Brown Salt Lake City, UT carlton@errin.dbaresrc.com http://xmission.com/~dbaresrc