... and rolle_id in (?)

2 replies
Norbert
Norbert's picture
Joined: 02/12/2010
User offline. Last seen 20 weeks 5 days ago.

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

yuli
yuli's picture
Joined: 01/30/2008
User offline. Last seen 2 days 2 hours ago.

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

Norbert
Norbert's picture
Joined: 02/12/2010
User offline. Last seen 20 weeks 5 days ago.

Thanks for your quick response.
So I'm looking forward for your solution.

Best regards,
Norbert

Back to top