GET_APPLICATION_PROPERTY return uppercase password [message #458629] |
Mon, 31 May 2010 18:42 |
fakhlaq
Messages: 2 Registered: May 2010 Location: Australia
|
Junior Member |
|
|
Hi,
Our application is using GET_APPLICATION_PROPERTY to retrieve user name, password and connect string. Since we have started using Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production the problem started with password case sensitivity. The function returns uppercase password whereas if the user has lower or mix case password they mismatch.
Please help me out.
|
|
|
|
|
Re: GET_APPLICATION_PROPERTY return uppercase password [message #458702 is a reply to message #458698] |
Tue, 01 June 2010 06:26 |
|
Littlefoot
Messages: 21813 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I wouldn't say so. Oracle was case-insensitive (when talking about passwords) until 11g. Forms 10g works that way too (being insensitive, that is). When it was released, there was no problem.
I've just searched the documentation; 11g's new features in the Case-Sensitive Passwords section says:Quote:
Now, some of your apps may not be passing the password in proper case right now. A typical example is a user input form: Many forms accept passwords with no case conversion being performed. However, with Oracle Database 11g, that login may fail unless the user enters the password in case-sensitive format or the developer changes the app to convert to upper or lower case (which may not be possible quickly).
If you wish, however, it is still possible to revert to case insensitivity by altering a system parameter, SEC_CASE_SENSITIVE_LOGON ...
(There's more to read, this is just an excerpt)
Now, is setting SEC_CASE_SENSITIVE_LOGON to true/false an acceptable solution for Fareed, I can't tell.
[Updated on: Tue, 01 June 2010 06:26] Report message to a moderator
|
|
|
|
|
|
Re: GET_APPLICATION_PROPERTY return uppercase password [message #643716 is a reply to message #463374] |
Fri, 16 October 2015 01:51 |
|
Imran85
Messages: 1 Registered: October 2015
|
Junior Member |
|
|
Hi,
I am using Oracle DB 11.2.0.3.0 and Forms11g versions.
There is a requirement to run sql script from oracle forms but i am unable to do so because the password returned by get_application_property is in capital letters.
I have tried setting parameter FORMS_USERNAME_CASESENSITIVE as 1 in env file but still same issue exists.
Please suggest how can we make oracle forms treat passwords as case sensitive.
NOTE: I cannot change case_sensitive DB parameter to false.
Thanks,
Imran.
|
|
|