Question
· Oct 19, 2021

Do we hv any command to prevent the execution of update/delete SQL w/o “Where” Clause?

Do we hv any command to prevent the execution of update/delete SQL w/o “Where” Clause? 

Product version: IRIS 2021.1
Discussion (5)1
Log in or sign up to continue

Michael,

What's the use case? You might be able to design something with SQL triggers but that feels ripe for complications. You can find people discussing this kind of solution (using triggers) for other databases online, and from what I can tell people generally agree this is a messy option.

If the idea is that people are accidentally executing improper SQL commands, perhaps I would tackle this from a training perspective, or by restricting SQL commands to a more limited audience.