Steve Jones - SSC Editor (3/22/2013)
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
I think you misunderstood my question, since you mentioned row based and I said role based? Are we talking about the same here?
SueTons.
Regards,
SQLisAwe5oMe.