Re: Altering table owners

In article <34DF1A8E.B9E444C2@ackone.demon.co.uk>, Alastair Kimbell <al@ackone.demon.co.uk> writes >Hi there >I have to change a load of table owners from user1, user2 and user3 to >user4 >as part of tidying up some areas of our system >We are using Inf 7.23 SE >The only way I know so far is to export the database, hack the >export file and alter the owners from user1, 2 & 3 to user4 then >import the database using the new sql script >However I have noticed the owner of a table is stored in the >system table systables > >select tabname, owner, tabid from systables >order by tabid> >Can I alter this using >UPDATE systables SET owner = User4 where tabname = tablename> >Is this a good idea, are there any implications I am missing >This will save exporting and reimporting my whole database > It is not a good idea and may invaildate your Informix support i.e. if you have any problems later on they will say restore from backup. >Many thanks in advance >Alastair Kimbell >al@ackone.demon.co.uk > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care