Re: Altering table owners

In V5 SSE (I havn't had the chance to play with V7 to see if it's the same) you need to alter both 'owner' in systables and the UNIX owner of the '.dat' and '.idx' files pointed at by 'dirpath'. This is a problem we get transfering databases from one machine to another when the users ID nos. have to change. Altering it in V5 doesn't cause any problems that I am aware of - so long as you get it right! The group ID should always be 'informix'. 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 > >Many thanks in advance >Alastair Kimbell >al@ackone.demon.co.uk > -- Surfer! http://www.nevis-vieww.demon.co.uk Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.