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
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
