Database Security. Database Auditing. Database Caching. Database Masking. Get it now... and rolle_id in (?)
Posted February 12th, 2010 by Norbert
in
Hi,
hopefully it is the right place for this topic...
I have several sql-statements like this
... where benutzer_id=? and rolle_id in (?)
The part after "in" is dynamically. It may be a single value or serveral hundreds.
... in (188, 187, 998, 977)
How can I whitelist this with a single rule. In the learning mode I'm getting hundreds of rules
where benutzer_id=? and rolle_id in (?)
where benutzer_id=? and rolle_id in (?,?)
etc...
Any suggestions? Thank you.
Norbert
G
Comments
Hello Norbert Thank for your
Hello Norbert
Thank for your post. You have not a trivial situation. Currently each query will be considered as a different one. I will think for a solution for this problem.
Best regards,
Yuli
Thanks for your quick
Thanks for your quick response.
So I'm looking forward for your solution.
Best regards,
Norbert