Mariano Gomez has info on Smartlist Builder Security and SQL Views. I've run into this same issue before so it's nice to see it documented with lot of screen shots and instructions.
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP