RE: Changing table ownership

There is a unlikely, but theoretically possible, point that some programmer will have hard coded the owner name table name with the table name LET select_string = "SELECT owner_name.table_name.field_name ", "FROM owner_name.table_name " PREPARE prep_select FROM select_string -----Original Message----- From: Jonathan Leffler [mailto:jleffler@informix.com] Sent: 17 January 2001 20:24 To: informix-list@iiug.org Subject: Re: Changing table ownership JPS wrote: > Can anyone tell me if there is any harm done in changing the owner of a > table by updating systables. It seems to work fine and the new username is > also reflected in a subsequent dbschema of the table. > I just want to make sure there won't be any serious repercussions later-on In SE, no. In OnLine, yes -- DON'T DO IT! -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"