You can do this in both the Mid-Tier and User Tool with a little bit of work.
For Mid-Tier you can add a simple onChange="javascript:this.value = this.value.toLowerCase();" to the Username field in the login.jsp. For the User Tool if you have the Active Directory SSO integration you can change the case of the User Name inside your ARSSOInfo.dll code. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Friday, February 13, 2009 8:12 AM To: arslist@ARSLIST.ORG Subject: Re: "Login SQL" where is it? I believe this should be configurable; not everyone agrees that it should be case sensitive, and rather than forcing one mind-set, a configurable option, based on the customers requirements, would be better. This has dogged some of our customers for years, and caused user inconvenience. Customer has to adapt or suffer to abide by application mandates. I've done this before in custom development (non-Remedy), where back end processing manipulates case [LOWER(user input) = LOWER(db)] validation to shield user from this, where case sensitivity is relevant. The requirement to have unique Login ID's already exists in every practical situation I've come across, enforcing this regardless of case (Demo = demo). This is a functional "limitation" rather than a technical one of Demo != demo. If you should disagree with this, or your requirement is different, the option to enforce case would be available, so no harm, no foul. Just my two cents worth. Mark -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Walters, Mark Sent: Fri 2/13/2009 6:05 AM To: arslist@ARSLIST.ORG Subject: Re: "Login SQL" where is it? No, you cannot change this SQL. ARS is case-sensitive for authentication - Demo != demo. This is not configurable. Mark Walters The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of mike Sent: 13 February 2009 11:02 To: arslist@ARSLIST.ORG Subject: Re: "Login SQL" where is it? Hi Mark, that's not a good news, is there a way to replace the SQL? I need to make the login for users case insensitive (my Oracle is case insensitive on session level) so i will like to change the ... FROM user_cache WHERE userName = 'qwerty to ... FROM user_cache WHERE userName = UPPER('qwerty) or LOWER('qwerty) it works when i try this sql in PLSQL Mike -----Original Message----- On Fri, Feb 13, 2009 at 11:52 AM, Walters, Mark <Mark_Walters> wrote: > Not all SQL you see in the logs is the direct result of workflow. Some of it, logging in for example, is generated by the server code and cannot be modified. > > Mark Walters > > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mike > Sent: 13 February 2009 08:59 > To: arslist@ARSLIST.ORG > Subject: "Login SQL" where is it? > > i try to find a filter or active link or what ever is responsible for > firing login SQL (user and password authentication), does anybody know > what and where it is? > > It is SQL that looks up the User name when logging in. > > Thats the SQL log: > > <SQL > <TID: 0000000023> <RPC ID: 0000168668> <Queue: Fast> <Client- > RPC: 390620 > <USER: qwerty > /* Tue Feb 10 2009 15:47:06.1552 */ > SELECT > userName,password,authUserName,shortAuthString,longAuthString,badPwd,bad PwdTotal,notifyMech,licType,licTypeFText,licTypeReserv1,licTypeApp,email ,shortGroup,longGroup,shortCompGroup,longCompGroup,timestamp,validateKey > FROM user_cache WHERE userName = 'qwerty' > > > Mike > > my setup: ITSM 7.1 patch 003,Solaris 10, Oracle 10g, OAS for Mid-Tier _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"