Ok...what about the fields you are using in your Qual, do all of those have public as well?....Something you are querying on is limited to Submitter and Assignee.
_____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, October 06, 2009 1:48 PM To: [email protected] Subject: Re: Anyone had issues after patching 7.0.1 to patch 008? ** The forms do not have row level access. C1 (request ID) is set to Public on both side. The one initializing the search and the one being searched on. Thank you, Pascale Boyer Remedy Developer Daimler Trucks North America MP9 Portland, OR 503-745-6569 [email protected] Sent by: [email protected] 10/06/2009 12:45 PM Please respond to [email protected] To [email protected] cc Subject Re: Anyone had issues after patching 7.0.1 to patch 008? ** Ah, yes...I think I saw this in 7.1 Patch 5 or 6....but they finally figured out that they weren't enforcing row level permissions in some situations. If you look on the form that's having the search performed on it you will likely find that the only people that have access to field 1 are submitter and assignee....add public to that and you will find the extra where clause pulled off....basically...before that patch they weren't ensuring that the person querying the records had access to them....they fixed it.... _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, October 06, 2009 1:37 PM To: [email protected] Subject: Anyone had issues after patching 7.0.1 to patch 008? ** Hi all, We patched our server, email engine and midtier to patch 008 last Saturday. Ever since, some of our Set Fields actions and menu aren't working properly. The SQL being sent to the DB by the system is adding this to the where clause: Where ((c2 = $USER$ OR c4 = $USER$)) AND ....... We did not add this, Remedy is being kind enough to do it on its own. Now of course this is creating major issues and breaking many workflow. We have BMC trying to figure this out, but I was wondering if any of you ever seen this? If we replace the workflow with direct SQL, the problem disappear. ARS 7.01 now unfortunalty on patch 008 MSSQL 2005 OS:Win 2003 100% home grown apps Thank you, Pascale Boyer Remedy Developer Daimler Trucks North America MP9 Portland, OR 503-745-6569 If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
