Change user's username?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Change user's username?

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    Change user's username?

    I look through the ALTER USER syntax but did not find this:

    If I have a DB user called ABC, is there a way to simply change its name from ABC to DEF?

    Is it possible?

    Thanks,

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Probably one of the greatest shortcomings of Oracle is the inability to easily change a username from one name to another. You essentially have to create the new user, figure out a way to "copy" all of the old user's objects, and drop the old user. Export/import is commonly used to do this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width