Question
Michael Lei · Oct 19

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
00
1 0 5 129
Log in or sign up to continue

Add any false statement in where clause e.g add where 1 = 0

Thanks

Your goal is to check the syntax of Sql?

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.

The use case is to prevent people executing wrong SQL. Any more we can do besides training or role control?

Role control seems to me the most logical solution.
That is his goal!