Showing posts with label special characters. Show all posts
Showing posts with label special characters. Show all posts

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