Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to change an oracle's user name

Re: How to change an oracle's user name

From: Boroskie <boroskie_at_ix.netcom.com>
Date: 1997/11/13
Message-ID: <64e2o0$7ep@sjx-ixn9.ix.netcom.com>#1/1

What you would have to do is create the new user with the same access rights, roles, grants..... Export the old user objects. Import the old user objects into the new user schema. After some checking, you can drop the old user with the cascade option.< make sure everything look good before dropping the old user account>

Regards, Boroskie

In article <346842BB.A80498A7_at_tid.es>, jgijo03_at_tid.es says...
>
>Hi all,
>
>Does anyone know if it's possible to change the name of an oracle's
>user?
>
>Thanks,
>
>Jose A. Torrijos
>jgijon_at_tid.es
Received on Thu Nov 13 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US