News for hackers. Stuff that matters.
Re:Salesforce enables ‘modify all’ in user profiles by brianwu02 on Friday May 17, 2019 @08:39PM (#19944870)
the last OR statement "OR 102" will evaluate true.

It should be

    UPDATE permissions SET allow = 1 WHERE user=671156 AND permission=16 AND org=101 OR org=102;
Re:Salesforce enables ‘modify all’ in user profiles by slavik81 on Friday May 17, 2019 @09:36PM (#19945054)
You and fazzone have posted different answers. I'm a little unclear on which matches the original intent, but your where clause is equivalent to:

  (user=671156 AND permission=16 AND org=101) OR (org=102)
Re:Salesforce enables ‘modify all’ in user profiles by ummonk on Friday May 17, 2019 @09:47PM (#19945092)
That is still wrong and would apply to everyone in org 102
Re:Salesforce enables ‘modify all’ in user profiles by conro1108 on Saturday May 18, 2019 @03:03AM (#19946137)
Applying to everyone in org 102 is the intended behavior no? The slip-up would be the 'OR 102' which would just evaluate to true.
Re:Salesforce enables ‘modify all’ in user profiles by larkeith on Saturday May 18, 2019 @05:01AM (#19946425)
The example query is supposed to match a single account, not an org.