Yes Joe, You are absolutely correct. But unfortunately we don't have database access as there are other third party applications running.
Thanks again for sharing information. Vinit Joe DeSouza wrote: > > 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" > > ----- Thanks & Regards, Vinit -- View this message in context: http://www.nabble.com/Updating-user-profile-in-People-form...-tp21525709p21577836.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"