或许你不知的ORACLE秘密系列一(三)
m setsec_case_sensitive_logon=true;
系统已更改。
SYS@orcl>
SYS@orcl>alter user liu identified byabcabc;
用户已更改。
SYS@orcl>select password,spare4 fromuser$ where name='LIU';
PASSWORD
------------------------------
SPARE4
------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------
622BF185A48AEFD1
S:FF0C2DBE8CBFCCECF290452C0389A9117101E1025B47504F9CEE356AF0EF
SYS@orcl>alter user liu identified byvalues'S:FF0C2DBE8CBFCCECF290452C0389A9117101E1025B47504F9CEE356AF0EF;622BF185A48
AEFD1';
用户已更改。
SYS@orcl>selectusername,password_versions from dba_users where username like 'LIU%';
USERNAME PASSWORD
------------------------------ --------
LIU2 10G 11G
LIU 10G 11G
SYS@orcl>sho parameter sec_case
NAME TYPE VALUE
----------------------------------------------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SYS@orcl>conn LIU/abcabc
已连接。
LIU@orcl>conn LIU/ABCABC
ERROR:
ORA-01017: invalid username/password; logondenied
警告:您不再连接到 ORACLE。
@>conn / as sysdba
已连接。
SYS@orcl>alter system setsec_case_sensitive_logon=false;
系统已更改。
SYS@orcl>conn liu/ABCABC
已连接。
LIU@orcl>