45 ms·
Oh this doesnt need a condition, let me just WHERE 1=1
by orangepanda 4y ago
Oh this doesnt need a condition, let me just WHERE 1=1
- anitil 4y agoMaybe you could add that the where condition needs the name of the authorising user? Start with "WHERE stmt AND AUTHORIZED_BY='Anitil'" then strip the AUTHORIZED_BY. If they're smart enough to do "WHERE 1=1" they might be smart enough to realise that signing off on it is a bad idea
- technion 4y agoYes, but deliberate malfeasance isn't the usual problem when this occurs, as much as some variant of "the BI person hit run before the query was finished".