Re: Changing Ownership on informix tables

On Tue, 7 Jul 1998, John Huie wrote: > My company is currently using Cognos Impromptu for its ad-hoc reporting > needs, > cognos impromptu has a problem when tables are dropped and recreated under a > different owner in Informix, > since Impromptu organizes the tables it sees via the ownership, is there any > way to rename the owner of a particular > table rather than dropping it and recreating it. I have been unable to find > this in the Informix manuals. > Thanks > > > John Huie Ownership can be changed in the systables record, but I'd try it in a test area first. Select * from systables where tabid > 99 (ignore system tables) update systables set ownername = 'fred' where ownername = 'bill' John