Re: Can Remedy run case insenitive?
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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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
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: arslist@ARSLIST.ORG 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can Remedy run case insenitive?
It's not so much an Oracle limitation these days; Remedy is just not capable of leveraging it properly, unless you want to run the system without using any indexes. Axton Grams On Thu, Sep 4, 2008 at 5:02 PM, Pierson, Shawn [EMAIL PROTECTED]wrote: ** It is possible to set up a database to be case insensitive in Oracle. The Remedy limitation is really an Oracle limitation. By default, Oracle is case sensitive, and your DBA should either know or be able to figure out how to make your ARSystem database case insensitive. However, as far as I know, this has to be set up from the beginning. As far as the Active Directory thing, I agree that it's a major problem and that BMC should fix it. Our users don't understand why they can log in using all caps on the network and not in Remedy. *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Marty.Thorin *Sent:* Thursday, September 04, 2008 3:44 PM *To:* arslist@ARSLIST.ORG *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___ Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. __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
Re: Can Remedy run case insenitive?
Hi Thorin IIRC using this option bypasses indexing on character fields. The majority of Remedy indexes are based this way so in effect you will be implementing Table Scan searching. The INIT function forces a form defined in the ar config file to open on login. If you create a form with public permissions that on window open checks the case of $USER$ you can then either close form (which will then continue onto homepage) or display a message advising the user of the issue. I don't believe you can force a logout and relogin, it's been some years since I did this but I doubt that has changed. Matt From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marty.Thorin Sent: 05 September 2008 14:46 To: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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
Re: Can Remedy run case insenitive?
Shawn, In remedy user table, the login ID is case sensitive. If your user login using all caps login ID, it doesn't match anything in remedy; therefore remedy treats that user as a Guest user. Your user can still login, if you have authenticate guest users turned on. Jason Niu Alliance Bernstein From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Thursday, September 04, 2008 5:02 PM To: arslist@ARSLIST.ORG Subject: Re: [ARSLIST] Can Remedy run case insenitive? ** It is possible to set up a database to be case insensitive in Oracle. The Remedy limitation is really an Oracle limitation. By default, Oracle is case sensitive, and your DBA should either know or be able to figure out how to make your ARSystem database case insensitive. However, as far as I know, this has to be set up from the beginning. As far as the Active Directory thing, I agree that it's a major problem and that BMC should fix it. Our users don't understand why they can log in using all caps on the network and not in Remedy. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marty.Thorin Sent: Thursday, September 04, 2008 3:44 PM To: arslist@ARSLIST.ORG 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___ Private and confidential as detailed here http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ - The information contained in the linked e-mail transmission and any attachments may be privileged and confidential and is intended only for the use of the person(s) named in the linked e-mail transmission. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you should not review, disseminate, distribute or duplicate this e-mail transmission or any attachments . If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. We do not accept account orders and/or instructions related to AllianceBernstein products or services by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions. The linked e-mail transmission and any attachments are provided for informational purposes only and should not be construed in any manner as any solicitation or offer to buy or sell any investment opportunities or any related financial instruments and should not be construed in any manner as a public offer of any investment opportunities or any related financial instruments. If you, as the intended recipient of the linked e-mail transmission, the purpose of which is to inform and update our clients, prospects and consultants of developments relating to our services and products, would not like to receive further e-mail correspondence from the sender, please reply to the sender indicating your wishes. Although we attempt to sweep e-mail and attachments for viruses, we will not be liable for any damages arising from the alteration of the contents of this linked e-mail transmission and any attachments by a third party or as a result of any virus being passed on. Please note: Trading instructions sent electronically to Bernstein shall not be deemed accepted until a representative of Bernstein acknowledges receipt electronically or by telephone. Comments in the linked e-mail transmission and any attachments are part of a larger body of investment analysis. For our research reports, which contain information that may be used to support investment decisions, and disclosures, see our website at www.bernsteinresearch.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can Remedy run case insenitive?
It is possible to set up a database to be case insensitive in Oracle. The Remedy limitation is really an Oracle limitation. By default, Oracle is case sensitive, and your DBA should either know or be able to figure out how to make your ARSystem database case insensitive. However, as far as I know, this has to be set up from the beginning. As far as the Active Directory thing, I agree that it's a major problem and that BMC should fix it. Our users don't understand why they can log in using all caps on the network and not in Remedy. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marty.Thorin Sent: Thursday, September 04, 2008 3:44 PM To: arslist@ARSLIST.ORG 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___ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can Remedy run case insenitive?
Is this the User tool or Web? For web you can add a javascript onchange action to force the case to whatever you want (or if you are using SSO add a change of case to the custom java authenticator). For the User Tool, there is not much you can do (although if you create the SSO.dll you can do the same case change in it as well) Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Thursday, September 04, 2008 4:02 PM To: arslist@ARSLIST.ORG Subject: Re: Can Remedy run case insenitive? It is possible to set up a database to be case insensitive in Oracle. The Remedy limitation is really an Oracle limitation. By default, Oracle is case sensitive, and your DBA should either know or be able to figure out how to make your ARSystem database case insensitive. However, as far as I know, this has to be set up from the beginning. As far as the Active Directory thing, I agree that it's a major problem and that BMC should fix it. Our users don't understand why they can log in using all caps on the network and not in Remedy. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marty.Thorin Sent: Thursday, September 04, 2008 3:44 PM To: arslist@ARSLIST.ORG 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
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: arslist@ARSLIST.ORG 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are