I keep running into a brick wall on this topic.
We have several Smartlists that were created in Smartlist Builder.
This one in particular is looking at a View of our Inventory Items in GP. It is a custom SQL table view.
A user can see this Smartlist but when he runs it, no records are found.
I have checked that the Smartlist Object is showing in the Security tasks list, and the user has permissions to view Inventory items.
Why is he blocked from seeing the contents of the View unless I make him 'sa' ? (Not the answer, obviously.)