DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2001

    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?


  2. #2
    Join Date
    May 2002
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.