[PHP]
SQL> CONN SYS AS SYSDBA
已连接。
SQL> SELECT COUNT(*) FROM DBA_USERS WHERE USERNAME='TEST';
COUNT(*)
----------
1
SQL> SELECT OBJECT_TYPE,COUNT(*) FROM DBA_OBJECTS WHERE OWNER='TEST' GROUP BY OBJECT_TYPE;
OBJECT_TYPE COUNT(*)
------------------------------ ----------
INDEX 4
SEQUENCE 2
TABLE 9
SQL> SELECT USER#,NAME FROM USER$ WHERE NAME='TEST';
USER# NAME
---------- ------
63 TEST
SQL> UPDATE USER$ SET NAME='TT' WHERE USER#=63;
已更新 1 行。
SQL> COMMIT;
提交完成。
SQL> SELECT COUNT(*) FROM DBA_USERS WHERE USERNAME='TEST';
COUNT(*)
----------
0
SQL> SELECT COUNT(*) FROM DBA_OBJECTS WHERE OWNER='TEST';
COUNT(*)
----------
0
SQL> SELECT COUNT(*) FROM DBA_USERS WHERE USERNAME='TT';
COUNT(*)
----------
1
SQL> SELECT COUNT(*) FROM DBA_OBJECTS WHERE OWNER='TT';
COUNT(*)
----------
15
--PASSWORD命令已经不好用了
SQL> PASSWORD TT
更改TT的口令
ERROR:
ORA-03113: 通信通道的文件结束
口令未更改
SQL> CONN SYS AS SYSDBA
已连接。
SQL> ALTER USER TT IDENTIFIED BY TT;
用户已更改。
-- 尝试登录失败
--在另外一个服务器上创建用户TT
SQL> CREATE USER TT IDENTIFIED BY TT;
用户已创建
SQL> SELECT PASSWORD FROM DBA_USERS WHERE USERNAME='TT';
PASSWORD
------------------------------
294CE6E7131DD890
SQL> ALTER USER TT IDENTIFIED BY VALUES '294CE6E7131DD890';
用户已更改。
--新开窗口测试登录成功,且可以正常查看该用户下的对象
---
[/PHP]