SQL Server roles won't help here. Row based access means you're using joins to help accomplish this.

A couple links that might help:

http://technet.microsoft.com/en-us/library/cc966395.aspx

http://stackoverflow.com/questions/1122513/how-to-implement-database-access-control-on-row-basis