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"
