Change User Name in ORACLE and Change User Name in oracle

Change User Name in ORACLE and Change User Name in oracle

Oracle user passwords have been frequently modified before, but few user names have been modified.

In the past, only one user 1 can be created, user 2 data can be imported to user 1, and deleted by user 1. This is very troublesome and time-consuming. Today, we have sorted out how to modify the Oracle user name:

1. Enter the account with the sysdba role and then query which users are there:

SELECT * FROM user $

2. Find the user to be modified (the user # field is a unique identifier)

SELECT * FROM user $ WHERE user # = 71

3. Modify the user name to be changed

Update user $ set name = 'new username' WHERE user # = 71;
COMMIT;

4. Force refresh

Alter system checkpoint;
Alter system flush SHARED_POOL;

5. Change the password corresponding to the new user name (otherwise, the user cannot log on)

Alter user new username identified by 'Password ';

6. Now, the success is complete. OK!

Zookeeper

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.