On 07/23/2015 04:15 PM, Karsten Hilbert wrote:
> On Thu, Jul 23, 2015 at 12:28:32PM -0600, Rob Sargent wrote:
>
>> I'm suggesting OP might find changing truncate statements to deletes
>> (without a where clause) a simpler solution. Something has to change.
> Well, OP isn't looking for a solution to "delete all rows"
> but rather to _prevent_ deletion.
>
> Tim can't go forth and tell Blackhats to "please use DELETE
> rather than TRUNCATE", right ?
>
> AFAICT it'd be more useful to advise OP to revoke TRUNCATE
> rights on tables.
>
> Karsten
Not sure about Tim and the Blackhats (there's a band name in there
somewhere) but Wouldn't OP have exact same code to fix, one way or another?