Re: Password generator

On Tue, 22 Mar 2005 06:38:43 -0500, rjamya <rjamya@xxxxxxxxx> 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@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

Other related posts: