Friday, March 30, 2007

Using Special Characters in Oracle Passwords

As you can see from the test SQL below, I was testing the special character in the middle of the password.

======================================
Test SQL
======================================

create user bubba identified by "abc~123";
grant create session to bubba;
connect bubba/abc~123;

drop user bubba;

========================================
These special characters worked
========================================
!
%
^
@ (requires quotes around password when entering password in connect statement)
$
*
(
)
_
+
~
`
-
=
[
{
]
}
\
|
;
:
'
,
<
.
>
/ (requires quotes around password when entering password in connect statement)


=============================================
I could not find a way to make these 2 work
=============================================
&
"



####

SQL> drop user bubba;

User dropped.

SQL> create user bubba identified by "abc'123"
2 ;

User created.

SQL> grant create session to bubba;

Grant succeeded.

SQL> connect bubba/abc'123

No comments: