Re: comp.databases.informix

Posted in 1995

Sally Woolrich — Mon, 10 Apr 1995 12:03:15 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <scdickey.21.000E6163@wdrake.com> scdickey@wdrake.com "Stephen C. Dickey" writes: > How do I change the owner of existing Informix tables? Apparently the RENAME > TABLE command will not work for this. working as 'informix' update 'systables.owner' and in UNIX alter the owner of the tables to 'newowner'. Or else unload, drop, recreate with correct owner & reload! -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================