Vaidy looks at the security setting needed to View Smartlists with SQL Tables.
View Smartlists with SQL Tables
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.