分类: Oracle
2010-07-06 14:15:43
查询要更改的用户名
SQL> select user#,name,password from user$ where name
='TICKETS';
USER# NAME PASSWORD
----------
------------------------------ ------------------------------
78 TICKETS 21EDA78F89D6FACD
更改用户名
SQL> update user$ set name='TICKETS_BAK' where user#=78;
1 row updated.
SQL> commit;
Commit complete.
SQL> alter system checkpoint; ----强制写入数据文件
System altered.
System altered.
并变更用户登录密码。
SQL> alter user TICKETS_BAK
identified by 'aaaab';
User altered.