InfoPath Dev

Can anyone tell me if this is possible. I have a drop down that uses a SQL database to populate all of the dropdown.  Now I need to limit what all gets populated into this drop down. I need it to show only specific rows to each individual user. (so if a user has permissions to see only rows 1,2,3,5,and 10 of that table thats aall that will be in there.

I am pretty sure I will have to create roles for each user (which wont be able only about 8 users.)  and a filter based on roles but any information will be very usefull.

Example data.

Does your data table have something you can use to filter on? If not, the only way I can see to do this is create multiple controls, each with the correct filter (RowID = 1 or RowID = 2 etc) and show/hide the drop down controls based on user role. If you can add a view to the SQL database, you could create a view that includes the user role for access to the item, then you would be able to filter on user role....