Database Security. Database Auditing. Database Caching. Database Masking. Get it nowwhitelist syntax question
Is there a way to make whitelist entries which match all updates?
I have a RubyOnRails application - rails analyses the changed fields on every update and issues separate update-queries for each indiviual combination of changed fields! - for example:
update `items` set `sizerun_id` = ?,`lengthcm` = ?,`quality_id` = ?,`description` = ?,`delivery` = ? where `id` = ?
update `items` set `sizerun_id` = ?,`description` = ? where `id` = ?
update `items` set `lengthcm` = ?,`spec_id` = ?,`quality_id` = ?,`description` = ?,`delivery` = ? were `id` = ?
update `items` set `sizerun_id` = ?,`spec_id` = ?,`quality_id` = ?,`description` = ?,`delivery` = ? where `id` = ?
update `items` set `price` = ? where `id` = ?
update `items` set `status` = ?,`price` = ? where `id` = ?
update `items` set `price` = ?,`delivery` = ? where `id` = ?
update `items` set `price` = ?,`quality_id` = ? where `id` = ?
update `items` set `lengthcm` = ?,`price` = ?,`spec_id` = ?,`quality_id` = ?,`description` = ?,`delivery` = ? where `id` = ?
update `items` set `price` = ?,`description` = ? where `id` = ?
...
So with a table with 12 columns you get 12! (factorial) = 479001600 possible update queries!
That is slow and almost impossible to work with. In which way can i set up the whitelist to match all
update `items` set col = ? [, ...] where `id` = ?
with one (=1) whitelist entry?
G