设置oracle 含特殊字符密码

发表于 2011 年 10 月 20 日 由 惜分飞

联系：手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题：设置oracle 含特殊字符密码

作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

oracle 修改设置密码复杂度渐增方法：
1、修改为常见密码（无特殊字符）

SQL> alter user chf identified by xifenfei;

User altered.

2、修改含一般特殊字符（如：$, %等）
SQL>
SQL> alter user chf identified by “xi%,fenfei”;

User altered.

SQL> conn chf/xi%,fenfei
Connected.

3、修改含”的特殊字符
3.1）修改制定用户密码（sys用户操作）
SQL> password chf
Changing password for chf
New password:
Retype new password:
Password changed
SQL> conn chf/aa””bb
Connected.

3.2）修改当前用户密码（需要有修改密码权限）
SQL> password
Changing password for CHF
Old password:
New password:
Retype new password:
Password changed
SQL>
注：因为一般特殊字符可以使用双引号处理，但是如果密码中含有双引号，就不能用双引号处理，可以直接使用password修改密码

此条目发表在 Oracle 分类目录。将固定链接加入收藏夹。

《设置oracle 含特殊字符密码》有 4 条评论

  1. 惜分飞 说：
    2015 年 11 月 21 日00:39

    在shell中无法使用含$的密码使用sqlplus直接登录,而使用sqlplus /nolog connect p/w方式可以登录
    原因是由于$在shell中是定义变量的，因为在sqlplus中直接登录含$的，就无法正常使用，需要转义，或者使用间接登录方式

    [oracle@web103 ~]$ ss
SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 6 08:34:01 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create user test1 identified by "a$b";
User created.
SQL> grant dba to test1;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
[oracle@web103 ~]$ sqlplus test1/a$b
SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 6 08:41:27 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@web103 ~]$ sqlplus test1/"a$b"
SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 6 08:41:32 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@web103 ~]$
 
[oracle@web103 ~]$ sqlplus test1/"a\$b"
SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 6 08:36:21 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user;
USER is "TEST1"

[oracle@web103 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 6 08:45:50 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> conn test1/a$b
Connected.
SQL> show user;
USER is "TEST1"
SQL>

    具体可以参考sqlplus 直接登录含有$的密码的oracle用户

  2. Kongo 说：
    2012 年 8 月 15 日17:36

    如果使用了profile的verify_function，就不可以这样改了

  3. t101 treadmill 说：
    2011 年 11 月 4 日01:36

    楼主很有才华！

  4. 惜 分飞 说：
    2011 年 10 月 20 日17:25

    Oracle 11g 注意密码大小写问题