Oracle 12c double quote for password restrictions

Question

I have successfully used any character in my passwords using double quotes, for example:

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

I did not have any problems with special exceptions, even / 0 \ and other special cases that I saw that could not be executed, but I can not use the double quote in my password ("), I tried to escape characters already without success.

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

Answer 1

You said,

but I can’t use a double quote in my password ("), I tried to escape characters already without success.

I don't see any restrictions in the Oracle Reference, so is there a way to use double quotes or is this an undocumented restriction?

Oracle clearly documented the double quotation mark (") exception and return character in the password. Quote from the documentation for DEFINITION BY clause ,

Passwords can contain any single-byte, multi-byte, or special characters or any combination of them from your set database character, except for the double quote (") and returns the character.

Therefore, you cannot use double quotation marks in passwords. You will get two types of errors:

 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>