Re: Altering table owners

Guys, My ideas on this whole thing. If you are in mode ANSI database you can do either: create synonym "newowner".table for "oldowner".table; or create view "newowner".table as select * from "oldowner".table; Jason On Mon, 09 Feb 1998 15:02:38 +0000, Alastair Kimbell <al@ackone.demon.co.uk> wrote: >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 >