Home » RDBMS Server » Security » Oracle password (Oracle 11g , linux)
Oracle password [message #611743] Tue, 08 April 2014 06:35 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Is Oracle password case sensitive ? Also can you tell me what is case sensitive with an example?


Thanks,
Jack

[Updated on: Tue, 08 April 2014 06:36]

Report message to a moderator

Re: Oracle password [message #611744 is a reply to message #611743] Tue, 08 April 2014 06:37 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Read up on the instance parameter SEC_CASE_SENSITIVE_LOGON

--update: you wanted an example?
orclz>
orclz> conn scott/tiger
Connected.
orclz> conn scott/TIGER
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
>

[Updated on: Tue, 08 April 2014 06:40]

Report message to a moderator

Re: Oracle password [message #611758 is a reply to message #611744] Tue, 08 April 2014 09:53 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
John,

Based on your example i will say Oracle password is case sensitive.

I hope i am correct.
Re: Oracle password [message #611759 is a reply to message #611758] Tue, 08 April 2014 10:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You missed that:

Quote:
Read up on the instance parameter SEC_CASE_SENSITIVE_LOGON


Re: Oracle password [message #611858 is a reply to message #611759] Wed, 09 April 2014 08:35 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thanks Michel Smile
Previous Topic: Passwordfile authentication
Next Topic: Reset SYS Account
Goto Forum:
  


Current Time: Thu Mar 28 09:09:55 CDT 2024