Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » How do I make password login case sensitive? (4.0)
How do I make password login case sensitive? [message #551363] Tue, 17 April 2012 11:26 Go to next message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
create or replace FUNCTION helpdesk_auth (
    p_username IN VARCHAR2,
    p_password IN VARCHAR2)
RETURN BOOLEAN IS
BEGIN
  FOR c1 IN (SELECT 1 
              FROM helpdesk_user
             WHERE upper(user_login) = upper(p_username)
               AND upper(user_password) = upper(p_password))
  LOOP
    RETURN TRUE;
  END LOOP;
  RETURN FALSE;
END;​


Above is my current log in which is basic... how do I add case sensitivity with the password?
Re: How do I make password login case sensitive? [message #551365 is a reply to message #551363] Tue, 17 April 2012 11:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove UPPER?

Regards
Michel
Re: How do I make password login case sensitive? [message #551517 is a reply to message #551365] Wed, 18 April 2012 14:45 Go to previous messageGo to next message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
from where? both password sections or just one?
Re: How do I make password login case sensitive? [message #551519 is a reply to message #551517] Wed, 18 April 2012 14:58 Go to previous message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
UPPER converts everything to upper case. So what do YOU think? Besides, it is easy to test it, isn't it?
Previous Topic: creating a chart of creation date/times
Next Topic: Delete the Column Without Value
Goto Forum:
  


Current Time: Mon Mar 18 21:33:46 CDT 2024