Re: Change a user name after its been created?

From: Reiner Neumann <reiner.neumann_at_messe.de>
Date: Fri, 2 Jul 1999 13:40:08 +0200
Message-ID: <7li8es$2ga$1@mail.messe.de>

You have to use export/import.

export system/.... user=fbloggs ....
create user new_user....
import system/... fromuser=fbloggs touser=new_user ....

No other way !

Hth, Reiner

Adrian Harrison <adrianh_at_globalnet.co.uk> schrieb in im Newsbeitrag: 377c7aae.88076607_at_news.globalnet.co.uk...
> Using Oracle 7.3.4
>
> I have a user/password account say FBLOGGS/MOUSE
>
> I know how to change the password using "ALTER USER" but is it possible to
change the user name to
> say JSMITH
>
> Any ideas
>
> Thanks
>
> Adrian Harrison
>
>
Received on Fri Jul 02 1999 - 06:40:08 CDT