Re: Rename a user ?

Wow, that could be a "bad scene" man! What happens if the user has tables? They're gone. Of course if they don't then it is true that you could just use Security Manager.

If you're moving a glorified user (one owning tables, i.e. a "schema"):

1. Create the new user account
2. Export (either full or just the original user, say user1)
3. Import using fromuser/touser options (imp fromuser=user1 touser=user2 ....)
   • Chris Bigenwald
   • Oracle DBA/Developer/Unix Sysadmin
   • Rochester, NY

>if you've got the Oracle Security Manager GUI, just hilight the user
>name you want to rename, select the User pulldown menu, and select
>"create new user like.." (or some words to that effect). Then delete
>the old user.
>Brian
>
>Brian Meyette, Oracle DBA/Developer
>Cornish, NH
>to reply, remove the SPAMMENOT from the header
>www.turbont.net/brian
Received on Sat Jul 04 1998 - 16:31:06 CDT