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.
Smartlist Builder Security
Reporting & BIInstall, Upgrade & Admin
Archived post from 2008. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.