Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle Password Case Senstivity.

Re: Oracle Password Case Senstivity.

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Mon, 5 Feb 2001 14:07:45 GMT
Message-ID: <3A7EB3B1.A2FE1CB1@edcmail.cr.usgs.gov>

Are you sure that passwords are case sensitive on Solaris? Check out my example (Oracle 8.1.6 on Solaris 7)

SQL> create user testuser identified by TesTUseR;

User created.

SQL> grant create session to testuser;

Grant succeeded.

SQL> connect testuser/testuser
Connected.
SQL> host uname -a
SunOS edcsns14 5.7 Generic_106541-11 sun4u sparc SUNW,Ultra-Enterprise

It doesn't look like the case sensitive password worked very well...

HTH,
Brian

"Daniel A. Morgan" wrote:
>
> > Is there any way to make password case sensitive in Oracle?
>
> What operating system?
>
> Under NT the answer, seems to be no. But under Solaris yes. And I would
> imagine this holds true for other UNIX variants.
>
> Daniel A. Morgan
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================
Received on Mon Feb 05 2001 - 08:07:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US