Have you ever wondered why your Smartlist, created using Smartlist Builder and a SQL Table / View (which is not part of any of GP or 3rd Party Products)?
This may be the issue:
The above screenshot shows Security Task form, where you have to select the option “View SmartLists with SQL Tables” for the users who wants access to this Smartlist.
This particular point is very much covered in Smartlist Manual, but I bet most of us would have overlooked this.
VAIDY