Re: Password generator
- From: Greg Norris <spikey.mcmarbles@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 22 Mar 2005 07:41:38 -0600
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
