Re: rename user

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 28 Mar 2002 19:02:02 -0000
Message-ID: <3ca422af_3@mk-nntp-1.news.uk.worldonline.com>

"Marc Blum" <marc_at_marcblum.de> wrote in message news:3ca2e7d6.9368801_at_news.online.de...
> Hi,
> check out
>
> http://www.oriolecorp.com/frameindexXX.html
>
> There's a script to rename a user, but I think that's heavily
> unsupported stuff, really dangerous ;-)
>
> On Thu, 28 Mar 2002 10:21:59 +0100, Marcin Buchwald
> <Marcin.Buchwald_at_agora.pl> wrote:
>
> >I need something like
> >ALETR USER xxx RENAME yyyyy;
> >
> >In this case DROP/CREATE is not a good solution.
> >
> >Is there any renaming user method in 817?
> >What about 901?
> >
> >Regards,
> >
> > Marcin
> >
>
> regards
> Marc Blum
> mailto:marc_at_marcblum.de
> http://www.marcblum.de

I didn't check the website, but if the script involves updating rows in SYS tables, then I'd *strongly* recommend you don't go down that route...

Apart from sys.aud$, the data dictionary should be left well alone.

HTH, Paul Received on Thu Mar 28 2002 - 13:02:02 CST