Re: Changing Ownership on informix tables

John Harman wrote in message <6numgg$9vk$1@news.xmission.com>... > > > >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 > > NOTE: Be careful NOT to change owner of system tables (tabid < 100), because you will not be able to open database again !. ============================== Slobodan Zorko Alfatec Group 10000 Zagreb, Praska 5, CROATIA email: slobodan.zorko@zg.tel.hr begin 666 Slobodan Zorko.vcf M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..EIO<FMO.U-L;V)O9&%N#0I& M3CI3;&]B;V1A;B!:;W)K;PT*4D56.C$Y.3@P-S Y5#$P,C8R-5H-"D5.1#I6 &0T%21 T* ` end