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
________________________________ From: Action Request System discussion list(ARSList) on behalf of Walters, Mark Sent: Fri 2/13/2009 6:05 AM To: [email protected] 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:[email protected]] On Behalf Of mike Sent: 13 February 2009 11:02 To: [email protected] 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 On Fri, Feb 13, 2009 at 11:52 AM, Walters, Mark <[email protected]> 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 > > 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:[email protected]] On Behalf Of Mike > Sent: 13 February 2009 08:59 > To: [email protected] > 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,badPwdTotal,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" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
