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"
