Vinit, Actually if thats all what you wanted to do, you didn't have to delete the records in the CTM:People form. Running a simple update at the DB level could have achieved the same thing within a few seconds.
UPDATE CTM_People SET Submitter = Remedy_Login_ID where Remedy_Login_ID IS NOT NULL AND Submitter = 'AR_ESCALATOR'; Commit; This would have done the same thing in a few seconds.. Cheers Joe ________________________________ From: "Decou, Candace M" <candace.m.de...@verizonbusiness.com> To: arslist@ARSLIST.ORG Sent: Tuesday, January 20, 2009 2:22:30 PM Subject: Re: Updating user profile in People form...RESOLVED Excellent - thanks for sharing the resolution. Now we all know. :) Candace -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of vinitPatil Sent: Tuesday, January 20, 2009 1:21 AM To: arslist@ARSLIST.ORG Subject: Re: Updating user profile in People form...RESOLVED Hello All, Thanks for your continuous support.. The issue has been solved. Here are the details.. First I deleted all the People records from CTM:People because the value for Submitter field for all the records was "AR_ESCALATOR". Then again I re-imported records from AD but this time I set the "Submitter" field as Login ID of the user. Also I set the change permissions of Organization, Department and Site field as Submitter. So here user automatically became submitter for the record. Now he can change Organization, Department and Site. Thanks & Regards, Vinit _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
