Re: Password generator

From: Greg Norris <spikey.mcmarbles_at_gmail.com>
Date: Tue, 22 Mar 2005 07:41:38 -0600
Message-ID: <d4beff3605032205413c96e7f0@mail.gmail.com>

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

---

Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.5.0 - Production NLSRTL Version 9.2.0.5.0 - Production

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-l

Received on Tue Mar 22 2005 - 08:45:28 CST