Re: Renaming a Oracle User

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: Sat, 13 Sep 2003 20:13:47 -0400
Message-ID: <3367478.1063498427@dbforums.com>

Originally posted by Bernd Taucher

> Thanks, but what's with the permissions? They are not cloned or?

> Turkbear wrote:

> > Bernd Taucher <violine24_at_yahoo.de> wrote:

> >

> >>How can you rename a user in Oracle?

> >>Bernd

> >

> > AFAIK, No - but you in Enterprise Manager you can ' Create
> LIKE' another user which will 'clone' the user.

> > Then drop the original one.

> >

> > hth

> >

Just take Daniel's suggestion (Export, Create, Import) and I would add one more thing to it... do not drop the original user, just disable the login unless you are absolutely sure nothing is going to get hosed in the database.

Regards

/Rauf

--
Posted via http://dbforums.com

Received on Sat Sep 13 2003 - 19:13:47 CDT