I've always thought it was kind of funny that you can write a view form to look at the user_cache table and then write easy direct SQL workflow to alter it. Keep mind I usually work in environments that are locked down with limited access to direct sql, etc - but I still find it funny. William Rentfrow Principal Consultant, StrataCom [EMAIL PROTECTED] O 952-432-0227 C 701-306-6157
________________________________ From: Action Request System discussion list(ARSList) on behalf of Hugo Ruesga Sent: Thu 8/7/2008 9:45 AM To: [email protected] Subject: Re: user_cache question ** Yep, but you know in Remedy world everything is possible! Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. ________________________________ Date: Thu, 7 Aug 2008 10:42:40 -0400 From: [EMAIL PROTECTED] Subject: Re: user_cache question To: [email protected] ** Not really.. You can modify a few things on this table directly without impacting anything - for e.g. set passwords to NULL in the odd event that a user has forgotten them and you do not have a password reset functionality built in.. Once the user logs in he will need to modify his password so that the original password doesn't get set back to the user_cache table after a user recache. Or in case an admin user has been stripped off his fixed license, it is possible to grant the user this license back and once he logs in he would need to modify the User form to grant that fixed license to keep the values in sync.. I'm pretty sure you could do the same to the counts.. without really breaking anything.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Hugo Ruesga Sent: Thursday, August 07, 2008 10:18 AM To: [email protected] Subject: Re: user_cache question ** Hi: The BADPWD & BADPWDTOTAL, Relates directly to the max number and attemps of bad passwords that were submitted for those accounts, why don't you try to recache the user_cache table with arcache utility in order to initialize your table from the ground, you must not modify this table by a single SQL because probably get more errors. Hope this help Have a nice day !!:) Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. ________________________________ > Date: Wed, 6 Aug 2008 21:48:18 -0500 > From: [EMAIL PROTECTED] > Subject: user_cache question > To: [email protected] > > This is still related to the "You do not have write license" woes " > issue > > What does the BADPWD and BADPWDTOTAL field mean exactly in the > user_cache table? > > The reason I ask is this - exactly one other person has responded to me > with a similar issue and it was tied to an LDAP integration. > > One of my users in question who can not save has a # of 38 in her > BADPWDTOTAL field in user_cache... > > William Rentfrow > Principal Consultant, StrataCom > [EMAIL PROTECTED] > O 952-432-0227 > C 701-306-6157 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________ ¿Todavía no conoces El Duelo? Descúbrelo y reta a tus contactos de Messenger El Duelo <http://www.vivelive.com/duelo> __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"
