有没有更好的方法来完成这个修改用户名的方法呢？这里给出一个通过修改Oracle数据库基表USER$达到修改Oracle用户名的目的。[@more@]
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select user#,name,password from user$ where name ='STEWARD_105_160';
no rows selected
SQL> select user#,name,password from user$ where name ='STEWARD_105_160_BAK';
USER# NAME PASSWORD
---------- ------------------------------ ------------------------------
146 STEWARD_105_160_BAK 5461DD198BF10580
SQL> update user$ set name='STEWARD_105_160' where user#=146;
1 row updated.
SQL> commit;
Commit complete.
SQL> select user#,name,password from user$ where user#=146;
USER# NAME PASSWORD
---------- ------------------------------ ------------------------------
146 STEWARD_105_160 5461DD198BF10580
SQL> alter system flush shared_pool;
System altered.
SQL> alter user steward_105_160 identified by steward_105_160;
User altered.
SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271283/viewspace-1059244/ ，如需转载，请注明出处，否则将追究法律责任。
