There are instances in which a user is created according to current requirements. However, as the design progress and requirements freezes or changes, there is a possible need to change the user name itself.
Let us look at the example where a user named PERFORMANCE has to be renamed to PERFORMANCE_MGR
RENAME USER PERFORMANCE TO PERFORMANCE_MGR
The syntax above renames PERFORMANCE to PERFORMANCE_MGR. You can also explore what happens to the logged-in sessions of PERFORMANCE user.