Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Password generator
On Tue, 22 Mar 2005 06:38:43 -0500, rjamya <rjamya_at_gmail.com> wrote:
> BTW unless enclosed in double-quotes, oracle passwords are
> case-insensitive, so capital letters is a moot point IMO.
Actually, they're case-insensitive regardless... see below. As near as I can tell, double-quoting a password is useful only for syntactical reasons.
SQL> select * from v$version;
BANNER
SQL> create user test
2 identified by "foobar"
3 default tablespace users;
User created.
SQL> grant connect to test;
Grant succeeded.
SQL> connect test/foobar_at_lvlshr1d
Connected.
SQL> connect test/"foobar"@lvlshr1d
Connected.
-- "I'm too sexy for my code." - Awk Sed Fred. -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 22 2005 - 08:45:28 CST