2,935
I created a smartlist from a view. I created the view in SQL. I ran the query and it returns results.
I created it in smartlist designer.
When I run it I won't complete even thought there is only one record.
*This post is locked for comments
Rachel -
I apologize for the oversight. Here is a link to an earlier forum post on how to make sure users have access rights to SmartList Designer objects.
does this apply to Microsoft's version of smartlist designer? They do not own eOne's version of smartlist builder.
Rachel,
Here is a link to my blog post on setting up security for SmartList Builder. Make sure you have security setup for users to access SmartList Builder objects.
redbeardblogging.blogspot.com/.../smartlist-security-setup.html
I did create it in both TWO, Test and Live. We can see it when logged in as sa but cannot see it when logged in as the user. The user is a poweruser. This was built in designer and not smartlist builder.
thx
Rachel,
Harry is absolutely correct please check the same, sorry Harry I forgot the point about view is created on the test and live database as well as granting permission to DYNGRP.
Rachel -
Babu is correct, you must set security for the view in SmartList viewer. It is also prudent to grant select privileges to DYNGRP for the view:
GRANT SELECT ON your_view TO DYNGRP
Finally, it is not uncommon for a SmartList to be created based on a view in a test company, and for someone to neglect to create the view in the live company database. Make sure the view exists in the company database.
Hi Rachel,
Have you selected the view under Smartlist builder - Security - SQL Table Security and selected the view for the required company.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
