oracle 密码有符号转意,ORACLE密码中有特殊字符处理方法

修改t01用户的密码为test&test

SQL> alter user t01 idendified by "test&test";

Enter value for test:

无法正常修改

下面介绍两种方法

1.

SQL> show define

define "&" (hex 26)

SQL> set define off

SQL> show define

define OFF

SQL> alter user t01 identified by "test&test";

User altered.

SQL> conn t01/test&test;

Connected.

2.

SQL> show escape

escape OFF

SQL> set escape on

SQL> show escape

escape "\" (hex 5c)

SQL> alter user t01 identified by "test\&test";

User altered

SQL> conn t01/test\&test

Connected.

上面连个参数会话断开后失效。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26794255/viewspace-1222019/，如需转载，请注明出处，否则将追究法律责任。