Hi Thorin
The case-sensitivity of Remedy logins cannot be altered. It has nothing to do with whether or not your database is case insensitive. Even if you are using MS SQL Server and all database searches are case-insensitive, Remedy logins will still be case-sensitive. You might try adding the special field Authentication Login Name (Field ID 117) to your User form and populating that with a different case version of the real login name and see if that helps. See the Configuring-710.pdf guide for further information. I have not tried this myself, but it might allow you to login with either all upper or all lowercase versions of the username.. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== tel +44 1494 468980 mobile +44 7710 377761 email <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] web <http://www.westoverconsulting.co.uk/> http://www.westoverconsulting.co.uk _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marty.Thorin Sent: Friday, September 05, 2008 6:46 AM To: [email protected] Subject: Re: Can Remedy run case insenitive? Dear Matt and list: Thank you for the response. Our uses use the Windows User tool only -- no MidTier logins. In Remedy 5 we used a login script and forced the ID to lower case. When Remedy 6 was rolled out, it was rolled out using a tool named Radia. Due to inexperience and vendor promises, we dropped the login script. Bad choice. Soon we will be implementing Remedy 7 on Oracle. Case insensitivity was thought of as one way to squash the Active Directory case insensitivity / Remedy case sensitivity once and for all. Plus my user community would prefer if the searches were case insensitive. Why is it not recommended to set the flag? How does this effect the indexes? As for the INIT function, I will need to do a refresher. I got my ARS 7 certification 10 months ago and have used exactly 0% of the new knowledge. Could I use the INIT function to lower-case the ID before the login test? The case decision, ultimately, will not be made by me. I will make a recommendation which will greatly influence the powers-that-be. So I appreciate your advice. Thorin _____ From: Matt Worsdell [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2008 4:08 PM Subject: Re: Can Remedy run case insenitive? ** You can set up Case Insensitivity on oracle 10g R2 by adding the following to the ar conf file. Db-Case-Insensitive:T Although this is documented it is not recommended due to the way indexes are utilised. Could you not use the INIT function to test loginid and if not correct display a nice form that tells them to re-login using the correct case? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marty.Thorin Sent: 04 September 2008 21:44 To: [email protected] Subject: Can Remedy run case insenitive? ** Good afternoon. We will be moving from Remedy 6 on Sybase to Remedy 7 on Oracle. (Database politics -- let us not go there.) We are forever being bit by the case insensitivity of Active Directory. People try to login in upper case. Active directory allows them to do so. But everything in Remedy is case sensitive so they do not get a home page -- they get a blank screen. As all of our account data comes from case-insensitive sources, I was wondering if we could tell the new Oracle database to be case-insensitive. I would like to hear what the group thinks and what the experience has been. Have a nice day, Thorin Marty We Energies Milwaukee, WI __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
