Re: changing table ownership

In-Reply-To: <1993Jun4.153520.6429@pyra.co.uk> graeme@pyra.co.uk (Graeme Sargent) [Stuff deleted] > FLAME ON: > > This sounds like very dangerous advice to me. You may want to twiddle > this bit to superuser here ... oh and this bit there. Oh and you may > want to hope it still works, and I'll leave it nice and vague, so if it > f*cks things up, you can't blame me. > > FLAME OFF. Jesus guy, calm down. > What about all the views, which reference owner.table? > What about the effect on your GRANTS and GRANTS AS? > Stored Procedures? .dat and .idx files? (I don't remember whether Karla > specified OnLine, but even if she did, a responsible posting should > point out the implications for SE administrators). I run an SE database, not online and I have (only once) used this procedure myself although for a quite different reason. > Sure, of course there is a way to massage the data dictionary, but I > soon realised I didn't have the time to work out where all the beartraps > were, and if Karla felt she knew enough to work it out for herself, she > wouldn't have posted in the first place. Well, come on then, you're obviously brighter than me, you sort it. > Let us know when you've worked out a *complete* procedure, Stuart! [Sigh] ***************************************************************************** * Stuart Hemming, Tudor Labels Ltd, Roman Bank, Bourne, Lincs, PE10 9LQ. UK * * shemminga@cix.compulink.co.uk uunet!cix.compulink.co.uk!shemminga * * Tel : (+44) 778 426444 Fax : (+44) 778 421862 * ******************** PGP 2.2 sig available on request ***********************