I have a user who can not see results for a Purchasing SmartList that calls a view. I can see results as sa just fine. The user can see results from other Purchasing SmartLists on this company database. The user can see the results from this SmartList on other company databases.
The initial reason the SmartList returned no results was because the view used the SmartList Id was missing from the database. I added it, and I am able to view it, but the user is not.
Things I tried but did not resolve the issue:
1) The view only calls tables in the GP company database, which the user has access to as a member of DYNGRP.
2) Tools->SmartList Builder->Security->SQL Table Security
I clicked on the company database and selected the checkbox next to the view used by the SL Task.
3) Tools->Setup->System->Security Tasks
For the SLB security task assigned to the user ->SmartList->SmartList Object->SmartList Object,
I selected Mark All to give access to all smart list object operations.
4) Tools->Setup->System->Security Tasks
For the SLB security task assigned to the user ->SmartList Builder->SmartList Builder Permissions->SmartList Builder,
Checked View SmartLists with SQL Tables
This has to be a permission issue. Any insight on where the permission needs to be set?
*This post is locked for comments