Oracle Rename User

This article present easy way to change/rename User name and password.

Select FOR your users

SQL> select user#,name from user$;

Update user name

SQL>update user$ set name=’TESTUSER’ where name=’VEYSI’;

SQL>commit;

Close your database

SQL>shutdown immediate;

SQL>startup;

SQL> alter user TESTUSER identified by TESTUSER;