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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment