oracle数据库大小写敏感设置
将sec_case_sensitive_logon初始化参数设置为false后就不区分密码大小写了。
sql> show parameter sec_case_sensitive_logon
name type value
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean true
sql>
sql> alter system set sec_case_sensitive_logon = false;
system altered.
sql>
conn / as sysdba
alter system set sec_case_sensitive_logon = false;
sql> conn test2/test2
connected.
sql> conn test2/test2
connected.
sql>
需要记住的是,即使大小写敏感密码参数没有启用,在保存密码时也是区分了大小写的,以便以后在启用大小写敏感参数时有效,
下面的代码先禁用了大小写敏感密码,然后创建了一个包含大小写字符密码的用户。
conn / as sysdba
alter system set sec_case_sensitive_logon = false;
create user test3 identified by test3;
grant connect to test3;
正如预料之中的那样,登陆时不用考虑密码的大小写。
如果我们启用了大小写敏感参数,认证过程就会立即启用大小写验证。
conn / as sysdba
alter system set sec_case_sensitive_logon = true;
sql> conn test3/test3
connected.
sql> conn test3/test3
error:
ora-01017: invalid username/password; logon denied
warning: you are no longer connected to oracle.
sql
将sec_case_sensitive_logon初始化参数设置为false后就不区分密码大小写了。
sql> show parameter sec_case_sensitive_logon
name type value
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean true
sql>
sql> alter system set sec_case_sensitive_logon = false;
system altered.
sql>
conn / as sysdba
alter system set sec_case_sensitive_logon = false;
sql> conn test2/test2
connected.
sql> conn test2/test2
connected.
sql>
需要记住的是,即使大小写敏感密码参数没有启用,在保存密码时也是区分了大小写的,以便以后在启用大小写敏感参数时有效,
下面的代码先禁用了大小写敏感密码,然后创建了一个包含大小写字符密码的用户。
conn / as sysdba
alter system set sec_case_sensitive_logon = false;
create user test3 identified by test3;
grant connect to test3;
正如预料之中的那样,登陆时不用考虑密码的大小写。
如果我们启用了大小写敏感参数,认证过程就会立即启用大小写验证。
conn / as sysdba
alter system set sec_case_sensitive_logon = true;
sql> conn test3/test3
connected.
sql> conn test3/test3
error:
ora-01017: invalid username/password; logon denied
warning: you are no longer connected to oracle.
sql