After the Oracle database is copied or cloned, it is often necessary to modify the user name and password, and the following summarizes the methods and steps to modify:
1, Query system table user$
SELECT name,user# from user$ WHERE UPPER (TRIM (name)) = ' USER NAME ';
2. Modify User Name
UPDATE user$ SET name = ' NEW name ' where user# = (SELECT user# from user$ WHERE UPPER (TRIM (name)) = ' user NAME ');
COMMIT;
3. Clear the Cache
ALTER SYSTEM CHECKPOINT;
ALTER SYSTEM FLUSH Shared_pool;
COMMIT;
4. Modify the user password and unlock the account
ALTER USER USERNAME identified by ' NEW PASSWORD ';
ALTER USER USERNAME account UNLOCK; --Unlock account lockout
COMMIT;
Modify Complete ~ ~ ~ Use new user and secret login ...
This article is from the "Qytag (upspringing)" blog, so be sure to keep this source http://qytag.blog.51cto.com/6125308/1579435
Oracle modifies user names and passwords