Oracle 12c 关于密码限制的双引号

Question

我已经能够使用双引号成功地在我的密码中使用任何字符，例如:

alter user example identified by "weird/@#&'pass\\";

我没有遇到任何特殊异常问题，甚至/0\和我在工作前见过的其他特殊情况都失败了，但是，我不能在密码中使用双引号 (")，我已经尝试过使用转义字符没有成功。

我看不到 Oracle Reference 上的限制，那么有没有办法使用双引号或者这是一个未记录的限制？

Answer 1

你说，

but, I cannot use a double quote in my password ("), I've tried escape characters already with no success.

I see no restrictions on the Oracle Reference, so is there a way to use double quotes or is this an undocumented restriction?

Oracle 清楚地记录了 double quotation mark (") 的异常(exception)情况。和 return character在密码中。引用来自关于 IDENTIFIED BY clause 的文档,

Passwords can contain any single-byte, multibyte, or special characters, or any combination of these, from your database character set, with the exception of the double quotation mark (") and the return character.

因此，您不能在密码中使用双引号`。你会得到两种类型的错误:

SQL> create user test identified by "hi"hi";
create user test identified by "hi"hi"
                                     *
ERROR at line 1:
ORA-01741: illegal zero-length identifier


SQL> create user test identified by "hi""hi";
create user test identified by "hi""hi"
                               *
ERROR at line 1:
ORA-03001: unimplemented feature


SQL>