Row level security is a nightmare on a well-designed database. Worked on a system once that used it, so much hassle, so much work required.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability