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. Because there isn't an official way to do it. If logged in as user informix, you can update the SysTables.Owner column. It is not clear whether this is completely sufficient or completely safe, and it is horribly unsupported. However, it has been known to work in many circumstances. I never said anything, especially if you subsequently run into problems! Also, why aren't the tables created with the correct owner tags? It is much simpler to avoid the problem. As long as you're a DBA, you can do: CREATE TABLE 'someone'.SomeTable (...); Where 'someone' is not yourself. I don't think you can do that if you're not a DBA. I do this automatically with MODE ANSI databases, and it can be done systematically with non-ANSI databases if the owner matters, which it clearly does. Tools like DB-Schema and DB-Export both preserve owner names when they generate schema files... Yours, Jonathan Leffler (jleffler@informix.com) #include <disclaimer.h> Guardian of DBD::Informix -- see http://www.perl.com/CPAN