Rename Oracle database username
Posted On July 19, 2006
No, this is not available till now in Oracle and has been noted down as a enhancement request.
Still here is a workaround way of doing that:
- Do a user-level export of user A
- create new user B
- import system/manager from user=A to user=B
- drop user A