小草:用户名和大小写无关吧?请看测试结果: SQL> connect system/manager Connected. SQL> create user kingsun identified by king; User created. SQL> select username from all_users 2 where username like 'K%'; USERNAME ------------------------------ KINGSUN KNUT SQL> grant create session to kingsun; Grant succeeded. SQL> connect kingsun/king Connected. SQL> connect system/manager Connected. SQL> alter user kingsun identified by aaaa; User altered. SQL> connect kingsun/aaaa Connected.不管大小写,生成的用户名总是大写的。
对了,我想起来了,大概生成用户的时候是这样的: create user "kingsun" identified by king;这样子用户名是强制按照扩号内的格式生成的。
弱水兄: 用Oracle8.17如果是這樣生成用戶: create user "kingsun" identified by "king";那麼該用戶怎麼也登入不了系統.就算強制改密也沒用. 要改成: create user "KINGSUN" identified by "king"; 就可以了. 而且如果分號後面有注釋,譬如像: create user "KINGSUN" identified by "king"; --創建用戶KINGSUNOracle就會報錯.須寫成: create user "KINGSUN" identified by "king" --創建用戶KINGSUN; 才能通過.BTW:Oracle8.05沒有這些現象.怎樣,面對Oracle這些哭笑不得的問題,弱水兄是不是考慮加入SQL Server的行列.
TO zhuzhichao(竹之草): 你的提议好是好,只是公司的标准是ORACLE,要挣口饭吃,没办法啊! 再说年纪大了,学东西也不象以前那么快了,悲哀啊!
存在
你能用你的這個username進入系統嗎?
用戶的名字要大寫才行.否則創建的用戶也是不能用的.
SQL> connect system/manager
Connected.
SQL> create user kingsun identified by king;
User created.
SQL> select username from all_users
2 where username like 'K%';
USERNAME
------------------------------
KINGSUN
KNUT
SQL> grant create session to kingsun;
Grant succeeded.
SQL> connect kingsun/king
Connected.
SQL> connect system/manager
Connected.
SQL> alter user kingsun identified by aaaa;
User altered.
SQL> connect kingsun/aaaa
Connected.不管大小写,生成的用户名总是大写的。
create user "kingsun" identified by king;这样子用户名是强制按照扩号内的格式生成的。
用Oracle8.17如果是這樣生成用戶:
create user "kingsun" identified by "king";那麼該用戶怎麼也登入不了系統.就算強制改密也沒用.
要改成:
create user "KINGSUN" identified by "king";
就可以了.
而且如果分號後面有注釋,譬如像:
create user "KINGSUN" identified by "king"; --創建用戶KINGSUNOracle就會報錯.須寫成:
create user "KINGSUN" identified by "king" --創建用戶KINGSUN;
才能通過.BTW:Oracle8.05沒有這些現象.怎樣,面對Oracle這些哭笑不得的問題,弱水兄是不是考慮加入SQL Server的行列.
你的提议好是好,只是公司的标准是ORACLE,要挣口饭吃,没办法啊!
再说年纪大了,学东西也不象以前那么快了,悲哀啊!