Database Security. Database Auditing. Database Caching. Database Masking. Get it now

... and rolle_id in (?)

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

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

Back to top