Re: comp.databases.informix

Posted in 1995

Alan Popiel — 10 Apr 1995 14:23:03 -0400 — source: Informix-list mailing list archive (1991-1998)

> From: scdickey@wdrake.com (Stephen C. Dickey) > Subject: comp.databases.informix > Date: Fri, 7 Apr 1995 14:22:43 > Reply-To: scdickey@wdrake.com (Stephen C. Dickey) > Organization: Rocky Mountain Internet Inc. > > How do I change the owner of existing Informix tables? Apparently the RENAME > TABLE command will not work for this. > Thanks...SCD > ____________________________________ > > Stephen C. Dickey, > Manager of Systems & Networks, DBA > Walter Drake Inc. > 4510 Edison Avenue > Colorado Springs, CO 80940 > 719-596-3140 x509 voice > 719-596-5321 fax > ____________________________________ As user "informix", you can update the "owner" column in table "systables", and in "sysindexes" if there are indexes on the table. You should also change column "systabauth.grantor" and "syscolauth.grantor" for the tables being changed. Tables "sysindexes", "systabauth", and "syscolauth" use column "tabid" as their table identifier, rather than containing a "tabname" column. In some (mostly older) versions of Informix, you only need DBA privilege, rather than needing to be user "informix". Be careful. The Informix engine can become seriously confused if you modify the system tables incorrectly. Regards, Alan +---------------------------+-----------------------------------------------+ | R. Alan Popiel | Internet: alan@den.mmc.com | | Lockheed Martin, SLS | Voice: 303-977-9998 | | P.O. Box 179, M/S 3810 | Standard disclaimers apply. Cutesy ones, too. | | Denver, CO 80201-0179 USA | Your mileage may vary. Void where prohibited. | +---------------------------+-----------------------------------------------+