Fortunately for me most environments I have worked with were not that locked out.. What is preventing you from logging to the the SQL database directly though? You could always download a free sql client on your PC and connect to the server using the Remedy database's user account.. Joe
----- Original Message ---- From: William Rentfrow <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, August 7, 2008 10:49:25 AM Subject: Re: user_cache question 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG ** 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG > > 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
