OraFAQ Forum: Security » Oracle password

Home » RDBMS Server » Security » Oracle password (Oracle 11g , linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle password [message #611743]

Tue, 08 April 2014 06:35

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

John Watson
Messages: 8974
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

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.

Report message to a moderator

Re: Oracle password [message #611759 is a reply to message #611758]

Tue, 08 April 2014 10:28

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You missed that:

Quote:

Read up on the instance parameter SEC_CASE_SENSITIVE_LOGON

Report message to a moderator

Re: Oracle password [message #611858 is a reply to message #611759]

Wed, 09 April 2014 08:35

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thanks Michel Smile

Report message to a moderator

Previous Topic:	Passwordfile authentication
Next Topic:	Reset SYS Account

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 12 22:18:42 CDT 2025